Insert conditional expressions in Report Designer

Insert a new conditional expression

In the design grid of the Report Designer, select a cell or an entire row by selecting the row number and selecting

Insert

then

Conditional Expression

.

Cell:

A Cell type conditional expression determines what prints in a cell. It can apply to the entire cell contents or to selected amounts, text and/or variables within the cell.
A Cell type conditional expression is selected if a cell or text in a cell is currently selected in the design grid.
A Cell type is selected by default when text in a cell is selected in the grid and you choose Insert > Conditional Expression. If the text in the cell is not selected, the text entered in the Conditional Expression dialog is inserted following the existing text.

Row:

A Row type conditional expression determines whether a row or group of rows will print.
A Row type conditional expression is selected by default unless a cell, text in a cell, or column is currently selected when you choose to insert a conditional expression.

Enter a unique description of up to 50 characters for the conditional expression. Note that the description must be unique for the current worksheet.

Use the Condition grid to build a conditional expression.

Operator	Description
<	Less than
<=	Less than equal
<>	Not equal to
=	Equal to
>	Greater than
>=	Greater than or equal to
Has data	The selected item includes data
Has no data	The selected item does not include any data
Contains	The selected item contains specified text
Does not contain	The selected item does not contain specified text

Action conditions

For
Row
conditional expressions, you can select a range of rows in the report to insert the current condition when the condition is met.
For
Cells
and
Row Text
conditional expressions, you can enter a value in the available field (including a formula and/or variable) to print when the condition is met.
For
Overdraft
conditional expressions the actual amounts print in the cell when the condition is met.

Complete condition
(marked by default). When this option is marked, the current condition must be true for any action to occur or information to print.
Test next condition
. When this option is marked, a new Condition tab is automatically inserted in the Conditional Expression dialog to allow subsequent conditions to be evaluated if the previous condition was not met.
Print:
For a Cell conditional expression, you can enter a value in the field (an amount, formula, variable, or text) to print if the condition is not met.
For a Row conditional expression, you can select a range of rows where the current condition is to be inserted if the condition is not met.

Edit an existing conditional expression

Remove an existing conditional expression