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 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.
In order to add the Query component:
- proceed to the Data tab of Report Designer;
- pick the Zeos MySQL Query 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 button;
- repeat the operation if you wish to add other query components to the report.
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.