Language:

HansaManuals

Creating a Report Using the Report Generator
Creating a Report Generator Report - Specifying the Primary Register
Creating a Report Generator Report - The Appearance of the Report
Creating a Report Generator Report - Choosing a Print Destination
Creating a Report Generator Report - The Width of the Report Window
Creating a Report Generator Report - Printing the Report
Creating a Report Generator Report - Adding White Space
Creating a Report Generator Report - Adding Searches
Creating a Report Generator Report - Adding a Secondary Register
   - Linking the Primary and Secondary Registers
   - Printing Information from the Secondary Register
   - Printing Elements with Red Line Overstrikes
   - If there are no Records in the Secondary Register
Creating a Report Generator Report - Using Variables and Formulae
Creating a Report Generator Report - Printing Information from Matrices
Creating a Report Generator Report - Bringing Information in from Other Registers
Creating a Report Generator Report - Page Breaks
Creating a Report Generator Report - Filtering Records (Print If)
Creating a Report Generator Report - Adding Check Boxes to the Specification Window
Creating a Report Generator Report - Adding Radio Buttons to the Specification Window
Creating a Report Generator Report - Searching for Records within a Period
Creating a Report Generator Report - Break Points, Subtotals and Totals
Creating a Report Generator Report - Blocks
Creating a Report Generator Report - Syntax
Creating a Report Generator Report - Useful Functions
Example Reports - Listing Sales Figures
Creating a Report Generator Report - Common Error Messages

Tutorials for Standard Accounts

Creating a Report Generator Report - Adding a Secondary Register

This page describes adding a secondary register to a Report Generator report. Please refer here for details about adding a primary register to the report.

---

A Report Generator report that only includes a primary register will usually have as its output a simple list of records in that register. Adding a secondary register allows you to add connected records in another register to the report. For example, in a Customer List report, it might be useful to list each Customer's Invoices underneath static details such as their Contact Number, Name, Category and Telephone Number. In this case, the Contact register would be the primary register and the Invoice register would be the secondary register. The report will loop through the Contact register. For each record in that register representing a Customer, it will then loop through the Invoice register to find Invoices belonging to that Customer.

Follow these steps to add a secondary register to a Report Generator report. These steps assume you have already added a primary register to the report, as described here:

  1. Open the Report Definition record and go to the 'Data' card. Click the [Register] button and complete the resulting 'Register' dialogue box as follows:

    Set the Level to 2, to signify that this is a secondary register. The example report will first list Customers in the Contact register (the Level 1 register) and then Invoices for those Customers. Invoices are therefore on the second Level. Please refer to the Registers page for more details about Levels.

  2. Click [OK] to close the 'Register' dialogue box. A new "Register:" line is added to the report display area, indented to show that it's on the second level:

    The Invoice register is one where you can invalidate records using the 'Invalidate' function on the Record menu. Whenever you add a register that supports the 'Invalidate' function to a report, a "Selection:" line will be also be added automatically, representing an automatic search that will remove invalidated records from the report. If necessary, you can remove this line from the report in the usual way (by clicking on it and pressing the Backspace key), or you can change it so that the report only lists invalidated records.
Having added the secondary register, please follow the links below for more details about:
---

Creating a Report Generator Report:

Go back to: