Breadcrumbs

Print conditions

Accountants Enterprise in Australia only

The Print Condition column is the first column in the Display view of the Format Editor window. It contains a printer icon. You can use this column to specify the conditions in which a row is to be included in a report. For example, you might only want to display a row if it contains a value other than zero. Setting a row to never be included in a report means you will not be able to use that result in another row. However, if the cell is included in a named range, the named range can be referenced in another row, even if the print condition is false.

To use the Print Condition column:

  • To always include a row, just leave the Print Condition column blank for that row.

  • If a row's inclusion is conditional, enter the condition in the Print Condition column for that row.

  • If you want a row to be excluded in all conditions, type =FALSE in the Print Condition column for that row. You would use this when you want a row to contain notes for the designer rather than content that is part of the Format.

Any text you type in this column does not display in your reports. A print condition on a row that is set to repeat is applied to each of the rows returned.

To add a print condition

To add a print condition to a row from within Report Designer (on the Formats tab):

  1. Click on the cell in the Print Condition row.

  2. Simply start typing your print condition.

  3. Click the Preview icon to preview the report.

Examples of Print Conditions

Example

Description

=PRINT9 

The row will only print if row 9 is also printed.

=CalculationRow 

The row will not print but cells on the row will be evaluated so the results of the cells can be re-used elsewhere in the same format.

=AND(CM.DirectorsReport.NPAT<>
0,CM.DirectorsReport.
ExtraordinaryI 
tems<>0) 

The row will only print if the total of all the accounts under the DirectorsReport.NPAT item is not zero and the total of all the accounts under the DirectorsReport.ExtraordinaryItems item is not zero.

=OR(C25<>0,D25<>0) 

The row will only print if either C25 or D25 contains a value other than zero.

=CM.Notes.Associates<>0 

The row will only print if the total of all the accounts under the Notes.Associates item in the Chart Map is not equal to zero.

=0<LEN(DB.Associates1.
Associate) 

The row will only print if the Associate field in the Associates1 table has a length greater than zero.

=1<RECORDCOUNT(DB. 
Director) 

The row will only print if the Director table is populated in more than one record.