There are 3 ways to create an external Report.
- Data Source: Report Generator uses the grid’s item source to create a ‘Simple Report’.
- Current Record: Report Generator uses the grid’s selected record to create a source, based on the type of report being created (Simple / Master-Detail).
- Master Record: Report Generator uses the grid’s master record and the item’s source to create a master-detail collection for a Master-Detail Report.
Data Source
Using the grid’s item source to create a Simple Report.
- Open the Report Designer, select ‘New > Simple Report’ and click ‘Next’.
- Select the ‘Client class’ from the list.
- Select all fields to be shown in the report.
- The ‘Select Data Connection’ panel now appears for the ‘New Report’. Check the ‘Preview Source’ box to provide the ‘Source’ externally and select: ‘Data Source’.
- Click on ‘Finish’.
- ‘Save’ the newly generated report and name it.
Master record
Use the grid’s master record and items source to create a master-detail collection for a ‘Master-Detail Report’.
- Open the Report Designer, select ‘New > Master Detail Report’.
- Select ‘Master Type & Detail Type’.
- Select ‘Master type Display Fields’ and ‘Select Detail type Display Fields’.
- Finally, select ‘Master Record’.
- ‘Save’ the newly generated report and name it.
Current record
Use the grid’s selected record to create a source based on the type of report being created (Simple / Master-Detail).
- Choose a ‘Report Type’ – ‘Simple’ or ‘Master Detail Report’.
- Select ‘Master type’ or ‘Detail Type’.
- Select the ‘Master type’ or ‘Detail type’ fields.
- In ‘Preview Source’, select ‘Current Record’.
- ‘Save’ the newly generated report and name it.
How to use Report as a Menu Item?
- Open ‘Tools > Local Menu’.
- Select the ‘Control Name’ used in ‘Client Class’ when creating the report.
- In ‘Control Type’, select ‘Report Preview’, and in ‘Control’, write the name of report that was saved in previous step.
- After saving, a new ‘Menu’ will be shown.
Note: If the above steps are skipped, the local menu can be created later.
- Selected Record: “SourceType=UseCurrentRecord”
- Master Record: “SourceType=UseMasterRecord”
- Data Grid: “SourceType=UseDataSource”