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
  a Search - Testing
  a Search - Adding a Second Search to the Specification Window
  a Search - Testing the Second Search
  a Search - Searching for Tags/Objects, Item Classifications, Contact Classifications and Persons
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 - Adding Check Boxes to the Specification Window - Inclusive Search Controlled by Check Boxes

This page describes using check boxes to control inclusive searches in Report Generator reports. Please refer here for details about controlling exclusive searches using check boxes.

---

Inclusive searches start from the point where no records in a particular register will be listed in a report, and records are then added to the report if they meet the criteria controlled by the check boxes. In this section, we will illustrate an inclusive search in a Contact List report by adding a check box that will include companies that have been marked as Customers. Follow these steps:

  1. Create a new report in the Report Generator module. On the 'Data' card, specify that the Contact register is to be the primary register. On the 'Layout' card, design the output of the report as required.

  2. Go to the 'Input' card and click the [Check Box] button above the report display area. Complete the 'Check Box' dialogue box as described here and illustrated below:

  3. Click the [OK] button. The check box will be placed in the report display area:

  4. Change to the 'Data' card. Click on the line in the report display area marked "Register: Contacts..." to specify that a search is to be carried out in the Contact register, and then click the [Print If] button.

  5. Enter a formula in the 'Print If' dialogue box as shown below:

    The formula is:

    cInclCust == 1 and vrContact.CUType == 1

    This states that if the check box (cInclCust) is ticked (i.e. if the value of cInclCust is 1), there will be a search in the Contact register for records that have been marked as Customers. "CUType" is the internal name for the Customer check box in the header of each Contact record. If cInclCust is not ticked (i.e. if the value of cInclCust is 0), the search will not take place.

  6. Click the [OK] button to add the Selection to the Contact register section of the report display area:

  7. When the report is produced without using the new option, it will be empty. When the report is produced using the new option, it will only list records in the Contact register that have been marked as Customers.

Adding a Second Check Box

You can add extra check boxes to the report, but they should also initiate inclusive searches (searches that add records to the initial selection). In this example, we will add a check box that will include companies marked as Suppliers in the report.
  1. On the 'Input' card, add a new check box to the specification window of the report, as described in step 2 above.

  2. As mentioned in the section describing exclusive searches, when there is more than one "Print If:" line in the report display area on the 'Data' card, they are treated as having the logical operator "and". There will be a search for records that meet the first condition and that meet the second condition. This is acceptable when there are two exclusive searches, but not when there are two inclusive searches. In this case, there should be a search for records that meet condition one or that meet condition two. Therefore, you cannot add a new "Print If:" line to the Contact register section, and instead you should double-click the existing "Print If:" line to modify it.

    Enter this formula:

    (cInclCust == 1 and vrContact.CUType == 1) or (cInclSupp == 1 and vrContact.VEType == 1)

    Note that each check box condition is enclosed in its own set of brackets. The two parts of a single inclusive check box condition are joined by "and", while several inclusive check box conditions are joined together using "or". This makes sure that there will be a search for records that meet condition one or that meet condition two. "VEType" is the internal name for the Supplier check box in the header of each Contact record.

    The specification window will now contain two options that you can use in the following ways:

    Neither option ticked
    The report will not list any records in the Contact register.

    One option ticked
    The report will list Customers or Suppliers (including those that are both), depending on the option chosen.

    Both options ticked
    The report will list Customers and Suppliers, including those that are both.
For details about the syntax that you should use when entering a formula in the 'Print If' dialogue box, please refer to the Syntax page.

Please follow the links below for more details about:

---

Go back to: