Progress
Report Builder
User’s Guide
Specifying Conditional Line Printing
By default, Report Builder prints every band line. If you want to print a line only when a specific condition occurs, you can specify that condition based on the value of a field. You can use any field (except a page total) in any table used in the report except a page total as a control field to trigger line printing. This allows you to print only the information needed.
Follow these steps to specify a print condition:
- Select one or more band lines.
- If you select a single band line, double-click or choose Properties
Band Line Properties. If you select multiple band lines, choose Properties
Band Line Properties. The Band Line Properties dialog box appears.
- In the Print Conditional Field field, select the field that you want to use as the basis for the print condition.
- Choose the appropriate condition. The condition choices vary depending on the field type. Table 3–4 lists the available choices.
- Choose OK to return to the report layout.
For example, if you have an invoice that subtotals line item amounts before calculating tax, you might not want a subtotal to print if there is only one line item. In this case, you can suppress printing the group footer line that contains the Subtotal field by following these steps:
- Create a report using the Order-Line table.
- Create an aggregate field called Total-Items, which counts the number of line items for each order.
- Create a logical calculated field called Print-Line to control printing of the subtotal group footer line.
- Set the Print field’s expression as follows:
This means that Print is a logical field whose value is true when there is more than one item.
- Assign the control field to the group footer line by selecting the line.
- Choose Properties
Band Line Properties. The Band Line Properties dialog box appears.
- Choose Print-Line from the Print Conditional Field drop-down list to display the names of all fields that can be used to control printing.
- Choose OK to return to the report layout.
- Choose Report
Preview. The Print Preview window appears.
When you display the report, the group footer line prints only when the value in the Print-Line field is true, meaning that it prints only when the invoice contains more than one line item.
The Report Builder indicates that a logical field has been assigned to control printing by placing a question mark in the band line status area.
Removing Print Conditions
Follow these steps to remove a print condition from one or more lines:
- Select the band lines.
- Choose Properties
Band Line Properties. The Band Line Properties dialog box appears. The name of the field assigned to control printing of the selected lines appears in the Print Conditional Field box.
- Deactivate the Enable Conditional Printing toggle box.
- Choose OK to return to the report layout.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |