This tutorial demonstrates how you can use a calculated field to conditionally change a label's text in a report.
See Conditionally Change a Label's Text to learn about the alternative approach to conditionally changing a label's text without using calculated fields.
See Data Binding Modes to learn more about the available binding modes.
The report created in this tutorial displays a custom text when the number of ordered units equals zero:
Do the following to conditionally change a label's text:
In this dialog, define the required condition for the calculated field (e.g., Iif([UnitsOnOrder] == 0, 'None', [UnitsOnOrder]). This expression means that if the UnitsOnOrder data field's value is equal to 0, the control's text will be set to None; otherwise, it will display the UnitsOnOrder field's value).
To close the dialog, click OK.
Finally, drop the required data fields (and the created calculated field as well) from the Field List on the report's Detail band.