Report Builder - Expression for background colors assistance

[JDIreland]

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

[AlexisOlson · Accepted solution]

Have you tried nesting like this?

IIF(Me.Value <= 4, "Green", IIF(Me.Value >= 7, "Red", "Orange"))

[88Bronco2]

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!

[88Bronco2]

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")))

[JDIreland]

Hi Alexis. This worked perfectly. Thank you very much for helping me out!