Report

Report Designer

Report Tool Bar

1. Report Properties
2. Notes
3. Saves Report to the Repository
4. Report Connection
5. Show only connections for the current project
6. Manage Versions
7. Add Version
8. Revert to the previous version
9. Make report Read Only

Creating Basic Report

Select report group from the objects tree and click “new”.

This will bring up the Report Properties tab as shown. Fill in the description and comment edit box if necessary:

Follow wizard steps

Report Wizard

Data Source

Enter report sql or use query builder

Query Builder

Fields Selector

Groups

Layout

Style

Click “Finish” to create the new report

Report Preview

Using the preview button, the report can be exported to PDF, Html or into an Excel file as a CSV. Reports can also be emailed, either by saving them into one of the formats stated or directly from the preview facility.

Passing Parameters into the Report

It is possible to pass parameters into the Report using variables

Object names

It is very important to use valid object names otherwise variables will not be replaced with the actual value

• For ADO(OleDB) use ADOConnection for connection object and ADOQuery,ADOQuery1…ADOQuery20 for queries
• For UniDac use UNIConnection for connection object and UNIQuery,UNIQuery1…UNIQuery20 for queries
• For BDE use BDEConnection for connection object and BDEQuery,BDEQuery1…BDEQuery20 for queries

Defining Variables

Defining SQL Parameters:

:P1 is an SQL parameter

Linking SQL Parameters to variables

Passing Parameters from Package into the report

Notes Dialogue

Video Tutorials