This document describes how to display different values in a report control based on a specified logical condition.
After you have bound a label to a field in a report control’s Expression property, you can make this control display different values based on a specified logical condition:
- Expand the Actions category and click the Expression property’s ellipsis button.
- In the invoked Expression Editor, specify the required expression.
Use the Iif function to define the condition. For example:
Iif([UnitsOnOrder] == 0, ‘None’, [UnitsOnOrder])
This expression means that if the data field’s value is zero, the control’s text is set to ‘None’; otherwise, it displays the actual field value.
When switching to Print Preview, you can see the report control displaying the assigned values.