Online Documentation for SQL Manager for MySQL

Adding database and query components


Adding database component

 

In order to add the Database component:

  • proceed to the Data tab of Report Designer;
  • pick the Zeos MySQL Database iconFastReport_ZeosDatabase component on the toolbar (on the left);
  • click within the working area - the corresponding ZeosMyDatabase1 icon appears in the area;
  • set the database connection and authorization parameters using the Properties Inspector.

 

Report Designer - Adding database component

 

 

Adding query component

 

In order to add the Query component:

  • proceed to the Data tab of Report Designer;
  • pick the Zeos MySQL Query iconFastReport_ZeosQuery component on the toolbar (on the left);
  • click within the working area - the corresponding ZeosMyQuery1 icon appears in the area;
  • set the database name and authorization parameters within the Properties Inspector;
  • double-click the ZeosMyQuery1 icon to open the SQL window;
  • input the SQL query that returns the required dataset and click the btnPostEdit button;
  • repeat the operation if you wish to add other query components to the report.

 

Report Designer - Adding query component

 

 

Note: The Properties Inspector panel which allows you to edit report object properties can be shown/hidden by pressing the F11 key.

 

 

Using the above given steps you can create as many queries as you need. In order to select a dataset returned by a query, select the Report | Data... main menu item of Report Designer to call the Select Report Datasets dialog. Pick the required query within the dialog and press OK.

 

Report Designer - Selecting datasets