SQL Query property

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.