You can specify print codes for each column using the Print Controlcell. For a description of available print codes, see Regular Print Control codes and Conditional Print Control codes .

Add print control codes to a report row

  1. In Report Designer, open the row definition to modify.

  2. Double-click the Print Controlcell.

  3. In the Print Controldialogue box, select a print code, or press and hold the Ctrl key to select multiple codes.

    Note Note

    You can also type the print codes directly into the Print Controlcell. Use commas to separate multiple print codes.

  4. Select any conditional print options.

  5. Click OK.

Regular Print Control codes

The following table describes the regular Print Controlcodes for a row definition.

Print Code

Interpretation of Print code

Description

NP

Non-printing row

Excludes the amounts in the row from being printed in the report and from calculations.

To include a non-printing column in a calculation, refer to the column directly in the calculation formula. For example, the non-printing row 240 is included in the following calculation: 230+240+250. However, the non-printing row 240 is notincluded in the following calculation: 230:250.

CS

Currency symbol; use currency format in this row

Includes the currency symbol in all non-percentage amounts. Percentage values never receive a currency symbol.

XD

Suppress row in account detail report

Suppresses the display of accounts on account detail reports or transaction detail reports. This is useful when a row includes multiple accounts that should not be listed in the account detail or transaction detail report.

X0

Suppress row if all zeros

Excludes a row from the report if all cells in that row are either empty or contain zeros. This print control is meaningful only when option to suppress zero balance is not selected in the report definition.

B0

Leave zero columns blank

Leaves any columns in the row that contain zero amounts empty.

XR

Suppress rollup

Suppresses a rollup. If the report uses a reporting tree, the amounts in this row are not rolled up into subsequent parent nodes.

SR

Suppress rounding

Prevents the amounts in this row from being rounded.

XT

Suppress row in transaction detail report

Suppresses the display of transactions in transaction detail reports. This is useful when a row includes multiple accounts that should not be listed in a transaction detail report.

Conditional Print Control codes

The following table describes the conditional Print Controlcodes for a row definition.

Conditional Print Control Code

Description

(none)

Clears the conditional print selection.

DR

Prints only the debit balances for this row.

CR

Prints only the credit balances for this row.

See Also