<< SharePoint 2019/SE 'Modern' Web PartsTable of contents 
SQL Chart Web Part

The SQL Chart Web Part allows to chart data selected from the specified SQL Server database, OLE-DB or ODBC data source.
See also /apps/page.asp?Q=5777
Sharepoint 2019 SQL Chart Web Part

Web Part Configuration:

enter the optional web part title

Web Part:

enter the below configuration options:

connection=enter the database connection string
pwd=enter the connection password
query=enter the SQL query
dataseries=enter one or more data series columns
labels=enter the chart label column
type=Pie (choose one of the available chart types)
legend=right (choose the legend position)
title=enter the chart title
chartcolors=red,green (enter the chart color for each series)
w=520 (enter the chart width in pixels
filter=LastName (enter the desired optional search filters)
axisabels=enter the chart axis labels (separated by a semicolon)

Web Part Configuration
Webpart Homepage & Download »

Please enter a comment below if you want to give feedback or have suggestions for improvements:

User Comments Post a Comment