EMS logo

Produits

SQL Manager for Oracle

Notre statut de partenariat

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

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 iconFastReport_ZeosDatabase Oracle Database component on the toolbar (on the left);
  • click within the working area - the corresponding OraDatabase1 icon appears in the area;
  • set the database connection and authorization parameters using the Properties Inspector.

 

Report Designer - Adding database component

 

Adding query component

  • proceed to the Data tab of Report Designer;
  • pick the iconFastReport_ZeosQuery Oracle Query component on the toolbar (on the left);
  • click within the working area - the corresponding OraQuery1 icon appears in the area;
  • set the database name and authorization parameters within the Properties Inspector;
  • double-click the OraQuery1 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

Saving the report