Conditionally Change the Label Text
This document describes how to display different values in the report control based on the specified condition.
Do the following:
Select the control and click the
f
button to invoke the Expression Editor:Specify the following expression for the
Text
property:Iif([UnitsOnOrder] == 0, 'None', [UnitsOnOrder])
This expression means that if the
UnitsOnOrder
data field value is 0 (zero), the label’s text is set to ‘None’; otherwise, the label displays theUnitsOnOrder
field value.Switch to Print Preview to see the result:
See Also