Hi I am looking to apply a global background colour using the details properties.
However I have individual text boxes that have their own background colour based on expressions that I want to overide the global details properites.
So I set up the global one with this expression
IIF(Fields!Number_of_Defendants.Value = 1 ,"Yellow","Transparent")
for the individual text box I used a nested IIF
=IIF(Fields!Bill_Rate.Value = 115,"Red",IIF(Fields!Number_of_Defendants.Value = 1 ,"Yellow","Transparent"))
This works but I'm wondering if their is a easier way so I don't have to have the 2nd clause.
Regards
No comments:
Post a Comment