Conditionally Change a Label's Text

To conditionally format a label's text

1. Create a new report.

2. Bind the report to a data source.

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

   

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

5. Locate its Expression property and click the ellipsis.

   The Expression Editor is then displayed.

   

   In this window, define the required condition for the calculated field (for example, Iif([UnitsOnOrder] == 0, 'None', [UnitsOnOrder]), which means that if the UnitsOnOrder data field's is equal to 0, 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 Detail band.

   

   The report is now complete.

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