Forum Discussion
Report Builder - Expression for background colors assistance
Hi there,
I am building a table report in Report Builder. The report has 3 colour ranges for Red, Amber and Green.
Red is values equal to or more than 7
Green is qual to or less than 4
Amber is anything else (which equates to 5 and 6 in this example)
In the 'Properties>Fill>BackgroundColour' of the desired Field, I have used a simple expression =IIF(Me.Value < = 4, "Green", "Orange") to cover Green and Amber colours and it works correctly - but whatever I try to do to add in a value for Red (> = 7 "Red") in the expression or by other means - I just cant find the right expression to that works, mostly getting an error. Just looking to see if someone can assist here and shed light on what will work for me as I have searched tutorials extensively and either have totally missed it or my particualt usecase is not present.
Many thanks
Have you tried nesting like this?
IIF(Me.Value <= 4, "Green", IIF(Me.Value >= 7, "Red", "Orange"))
4 Replies
Have you tried nesting like this?
IIF(Me.Value <= 4, "Green", IIF(Me.Value >= 7, "Red", "Orange"))Hi Alexis. This worked perfectly. Thank you very much for helping me out!
Hello, I am guessing you can figure this out, what is the syntax for two conditions? This is what I tried and its not working for me:
IIF(Fields!PHYCAP.Value >= 250 & Fields!SUM_INA_AVAIL_.Value >= 500, "Aqua",IIF(Fields!PHYCAP.Value >= 101 & Fields!PHYCAP.Value <= 249 & Fields!SUM_INA_AVAIL_.Value >= 250, "Aqua",IIF(Fields!PHYCAP.Value < 100 & Fields!SUM_INA_AVAIL_.Value >= 50, "Aqua","White")))
I very much appreciate any help you can provide!
FIXED IT:
=IIF(Fields!PHYCAP.Value >= 250 AND Fields!SUM_INA_AVAIL_.Value >= 500, "Aqua", IIF(Fields!PHYCAP.Value >= 101 AND Fields!PHYCAP.Value <= 249 AND Fields!SUM_INA_AVAIL_.Value >= 250, "Aqua", IIF(Fields!PHYCAP.Value < 100 AND Fields!SUM_INA_AVAIL_.Value >= 50, "Aqua", "White")))
