We'll have to:
- Select the textbox containing the value =Fields!Revenue_KPI.Value
- Edit Color property to say =IIF(Fields!Revenue_KPI.Value<0,"Red","Black")
- Select the textbox containing the value =Fields!Volume_KPI.Value
- Edit Color property to say =IIF(=Fields!Volume_KPI.Value<0,"Red","Black")
The alternative is to use the value of the textbox instead of the value of the dataset field to determine if the color of the text needs to be red or black.
- Select all the textboxes you want to format
- Edit Color property to say =IIF(Me.Value<0,"Red","Black")
No comments:
Post a Comment