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
Creating a Report Generator Report - Using Variables and Formulae
   - Declaring a Variable
   - Assigning a Value to a Variable
   - Printing a Variable
   - More Examples
   - An Alternative Way to Count Records
   - Joining Two or More Pieces of Information Together
   - Joining Strings and Non-Strings
   - Testing
Creating a Report Generator Report - Printing Information from Matrices
   - Linking the Register and its Matrix
   - Printing Information from a Matrix
   - Matrix Rows of Different Types
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 - Using Variables and Formulae

This page describes using variables in the calculations in a Report Generator report, and including them in the report output.

---

Much of the power and flexibility of the Report Generator relies on the use of variables. So far, you have placed variables in the specification window that you have then used to store search criteria. You have also used the variable that contains the current record to search for connected records in a secondary register. You can also use variables and formulae to include calculations in your report. For example, you can use them to count the number of records in the report, make percentage comparisons between two fields or calculate totals. On this page, we will illustrate the use of variables and formulae by adding a record count to the example Customer List report that we are using in this documentation. The record count will be printed at the end of the report to show the number of Customers in the list.

For details about each step in the process, please refer to the following links:

---

Creating a Report Generator Report:

Go back to: