Conditionally Change a Label's Text

<< Click to Display Table of Contents >>

RayVentory Data Hub > 12.5 u5 > Dashboards and Reports Customization Guide > Designing Reports > Shape Report Data > Specify Conditions for Report Elements 

Conditionally Change a Label's Text

This document describes how to display different values in a report control based on a specified logical condition.

 

After you bound your report to data and specified a bound data field in a report control's Expression property, you can make this control display different values based on a specified logical condition:

 

1.Expand the Actions category and click the Expression property's ellipsis button.
 
eurd-web-shaping-label-expression-property-for-custom-text
 

2.In the invoked Expression Editor, specify the required expression.
 
eurd-web-shaping-label-expression-for-custom-text
 
Use the Iif function to define the condition. For example:
 
Iif([UnitsOnOrder] == 0, 'None', [UnitsOnOrder])
 
This expression means that if the data field's value is zero, the control's text is set to 'None'; otherwise, it displays the actual field value.
 

When switching to Print Preview, you can see the report control displaying the assigned values.

 

eurd-web-shaping-label-custom-text-result