New article
Recently updated
Report Designer Example: Showing Yes/No instead of True/False in reports
To create a new Yes/No field you first need to identify the 'DataMember' of the original True/False field.
You can identify the DataMember using the following steps:
- Open a Report in Design View
- Hover the mouse pointer over the current True/False field
- In this example, the 'Available' field has a DataMember or 'IsAvailable'
- Keep note of this for the next step.
The next step is to create a new Custom Calculated Field, to do this:
- Right-click the Module Name within the Field List
- Select 'Add Calculated Field'
- The Calculated Field will now appear in the Field List
- Right Click the Calculated Field and select 'Edit Expression'
- Add the Expression in the format Iif ( [DataMember] , 'TrueValue' , 'FalseValue' )
- e.g. Iif ( [IsAvailable] , 'Yes' , 'No' )
- Click Ok to finish
- Drag and drop the field to your report