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

Previous   Next               Entire Chapter in Printable Form               Search  

This text refers to program version 5.3  

Adding a Secondary Register - If there are no Records in the Secondary Register

Primary register records are printed in the report even if there are no relevant records in the secondary register. In the example, a Contact record will be included in the report even if the record represents a Customer that has no Invoices. This is appropriate since the report is a list of every Customer in the Contact register, but in other circumstances you may want to remove these Customers from the report. To do so, follow these steps:

1. Return to the Report Definition record and go to the 'Layout' card.
   

2. In the example, the Contact Before and Contact After sections are printed once for each Customer. You can remove a Customer that has no Invoices from the report by preventing these sections from being printed. Double-click on each of these two sections in turn. The 'Section' dialogue box opens:
   

   

3. Check the Skip If Inner Loops Are Empty box and click the [OK] button.

From now on, the report will only contain Customers that have at least one Invoice.

Please click the links below for more details about:

• 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
  

• Blocks
  

• Useful Functions
  

• Common Error Messages
  

• Syntax for Print If conditions, Formulae and Code

Previous   Next   Top            Entire Chapter in Printable Form