SQL Query property

Previous Next

This is where you specify the SQL statement that retrieves the data represented in chart objects, Tree View Node objects, and List View objects:

· For Bar charts, the first column in the SELECT statement is used for the primary axis, all others for the secondary axis.

 

· For Pie charts, the first column in the SELECT statement is used to retrieve labels, the second column represents the data. All other columns will be ignored.

 

· For Line charts (also called "graphs"), the first column in the SELECT statement is used for the primary axis, all others for the secondary axis.