Conditionally Change a Label's Text

To conditionally format a label's text

1. To create a calculated field, in the Field List, right-click any item inside the dataset, and from the menu, choose Add Calculated Field.

   

2. In the Property Grid, set the field's Field Type property to String.

3. Locate its Expression property and click the ellipsis.

4. The Expression Editor is then displayed.

   

5. In this window, define the required condition for the calculated field (for example, Iif([LoopNo] == null, 'None', [LoopNo]), which means that if the LoopNo data field's value is null, the appropriate control's text will be replaced with None).

6. To close the window, click OK.

7. Drag the required data fields (and the created calculated field as well) from the Field List onto the report's reportDetail band.

   

   The report is now complete.

8. Switch to the Preview tab to view the result.