Chart control can display various charts from SQL query data.
Designer Options
Name - component name
Master - master component (SQL query can use master fields)
Classes - CSS classes
Width - component width
Height - component height
Chart width - chart internal width
Chart height - chart internal height
Grid color - color of grid lines in bar mode
Value format - format of bar values
X marks format - format for X axes marks
Y marks format - format for Y axes marks
Stack filter - comma separated stack values
X axis align - text align for X axis marks: middle, left, right
Stretch - stretch chart to visible area
SQL
SQL should return at least two fields. To refer to master component fields use :MASTERFIELD notation.
Series
Name - series name
Type - series chart type
X - name of X field in SQL
Y name of Y field in SQL
Stack - name of stack field in SQL
Side by side - display bar series side-byside
Marks - display values marks
Show sum in legend - show value in legend
Percent3d - 3d view depth
X order - expression for sorting X names
Stack order - expression for sorting stack names
Error - name of Error field in SQL
Q1 - QMax - name of fields in SQL
Box plot - draw boxplot.