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.

web interface : Enter chart report application basic information

web interface : Enter chart report application basic information

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 “;”.
i.e.

SELECT  
  City.Name,
  City.Population
FROM
  City
mysql web interface : chart report sample application

mysql web interface : chart report sample application

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.