EMS logo

Produits

SQL Manager for MySQL

Notre statut de partenariat

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for MySQL

Documentation en ligne

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

 

 


See also:

Adding dialog form

Adding report data

Viewing the report

Saving the report