Chart Report Application
Fastest MySQL Chart Report Application
‘Chart Report Application’ helps you convert the resultset to Pie, Bar,etc. chart report. It consists of a FORM (or not) and a ruled query SQL statement. When the user fill in the form, click the ‘submit’ button, the chart report will be shown.
Step1. Enter Application Information
Click the “Create Application” link, and select the “Chart Report Application” item, enter the application name, application description.
Step2. Build MySQL query for the application
All chart report application should contain one or more formatted query statement, “;” sperated, that is:
SELECT [ANY COLUMN] AS [CATEGORY(x-axis) LABELS], [NUMBER COLUMN] AS [DATA(y-axis) VALUES] FROM [TABLE] WHERE...;
You see, the query statement have 2 columns, the first is any data type column, the second must be a number column.
If you want to make multi series chart reports, sperated multi query statement by “;”.
SELECT City.Name, City.Population FROM City
Step3. Embed the application on your external page
If you want to embed the application on your external web page, like your wordpress blog, click here to learn how.