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
   - Adding a Report Title
   - Adding Column Headings
   - Adding Fields to 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
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 - The Appearance of the Report - Adding Fields to the Report

This page describes adding fields to a Report Generator report. Please refer to the following pages for details about other tasks that you may need to carry out when designing the output of a Report Generator report:
---

When designing the output of a report generator report, one of the most important tasks is to add fields to the report. Fields will print information from each record, and therefore will be printed as many times as necessary (i.e. each field will be printed once for each record). They should therefore be placed in the Register Before section, which will be printed once for each record. In the example Customer List that we are using in this documentation to illustrate the process of creating Report Generator reports, we will add fields for the Contact Number, Name and Telephone Number to the report.

  1. After creating a Report Generator report and specifying the primary register, go to the 'Layout' card and click the Register Before section (marked "Contacts vrContact Before" in our example) to select it.

  2. Click the [Field] button above the report display area. The 'Field' dialogue box opens:

    Field Name
    Paste Special    Fields in the register
    Choose the field that is to be printed. The 'Paste Special' list will show all the fields in the register you are working with (in this case, the Contact register). You cannot use fields from any other register: if you want to print information from another register you will need to use variables as described here.

    Left
    Specify here where the left-hand edge of the field is to be placed on the page, by entering a number of pixels from the left-hand edge of the page. If you're not yet sure where you want the field to appear, don't change the default. You will be able to change the position of the field later. To align the field with its column heading, enter the same left and right measurements here as you did for the heading.

    Right
    Specify here where the right-hand edge of the field is to appear on the page, by entering a number of pixels from the left-hand edge of the page. Together, the Left and Right measurements set the width of the field.

    Style
    Paste Special    Styles setting, System module or Style register, Report Generator module
    Use this field to assign a font and font style to the field. If you do not enter a Style, the font and font size specified in the Company Info setting in the System module will be used.

    Overstrike
    You can have the field printed with a red line drawn through it, depending on a condition that you enter here. This is described in more detail on the Printing Elements with Red Line Overstrikes page.

    Drill-down
    Select this option if you want to be able to drill down from the report into the register, when the report is printed to screen. In the example list of Customers, it might be useful to be able to click on a Contact Number in the report to open the relevant Contact record.

    Justification
    Use these options to choose whether the text is to be left- or right-justified within the field. Usually fields containing alphanumeric information or text should be left justified, while those containing figures should be right justified.

  3. When the 'Field' dialogue box is complete, click the [OK] button to close it. The field now appears in the report display area, in the Contact Before section:

  4. Repeat steps 2 and 3 three times to add fields for the Contact Name, Category and Telephone Number:

See also:
---

Creating a Report Generator Report:

Go back to: