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
note
The operator field in each row of the Condition grid is preceded and followed by a drop-down list of variables. You can select
Formula
to insert formulas and variables as part of the conditional expression.
Existing conditional expressions are tagged with a green triangle in the upper-right corner of a cell. An expression for a row is tagged in the row number column on the left side of the grid; an expression for a whole column is indicated in the column header section of the grid, and an expression for a single cell is indicated the upper-right corner of the specified cell.
Title rows in reports don't currently support conditional expressions, but you can customize title rows by inserting conditional expressions above title rows in the design grid.
For
Row
and
Row Text
conditional expressions, conditions are evaluated for all cells in the rows that are included in the condition.
You can build complex conditions by selecting
AND
or
OR
at the end of a row in the grid, which opens another row to add to the condition. Note that you can keep building to the current condition beyond the 6 visible rows in the Condition grid. When you have filled the 6 rows, and then select
AND
or
OR
at the end of the 6th row, a scrolling region is displayed so that you can add more items to the condition.
Multiple tabs are displayed in the
Conditional Expression
screen only if more than 1 condition is set up for the current expression.
A new tab is automatically added in the
Conditional Expression
screen (for example, Condition 1, Condition 2, and so forth) when you select
Test next condition
.

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.
note
When the condition is not met for an Overdraft conditional expression, a zero amount will print. You can format how the zero is displayed in the cells of the row from the drop-down list (Blank, Dash, Zero, or N/A).
When the
Test next condition
option isn't selected, subsequent condition tabs remain but are not evaluated when the condition is
false
.

Edit an existing conditional expression

Remove an existing conditional expression