HansaManuals Home   >> Standard ERP   >> Report Generator   >> Creating a New Report  

Previous   Next               Entire Chapter in Printable Form               Search  

This text refers to program version 8.5  

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:

• Linking the Primary and Secondary Registers
  

• Printing Information from the Secondary Register
  

• Printing Elements with Red Line Overstrikes
  

• Omitting Primary Register Records if there are no Records in the Secondary Register

---

Creating a Report Generator Report:

• Introduction
  

• Specifying the Primary Register
  

• The Appearance of the Report
  

• Choosing a Print Destination
  

• The Width of the Report Window
  

• Printing the Report
  

• Adding White Space to Improve Readability
  

• Adding Searches
  

• Adding a Secondary Register
  

• Using Variables and Formulae
  

• Printing Information from Matrices
  

• Bringing Information in from Other Registers
  

• Page Breaks
  

• Filtering Records - Print If
  

• Adding Check Boxes to the Specification Window
  

• Adding Radio Buttons to the Specification Window
  

• Searching for Records within a Period
  

• Break Points, Subtotals and Totals
  

• Blocks
  

• Syntax for Print If conditions, Formulae and Code
  

• Useful Functions
  

• Example - Listing Sales Figures
  

• Common Error Messages

Go back to:

• Home page for Report Generator manual
  

• Home page for Standard ERP manual

Previous   Next   Top            Entire Chapter in Printable Form