topic Re: Report Builder - Expression for background colors assistance in Report Server

Report Builder - Expression for background colors assistance

JDIreland — Mon, 22 Nov 2021 14:24:16 GMT

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

Re: Report Builder - Expression for background colors assistance

AlexisOlson — Mon, 22 Nov 2021 16:29:55 GMT

Have you tried nesting like this?

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

Re: Report Builder - Expression for background colors assistance

JDIreland — Mon, 22 Nov 2021 18:31:26 GMT

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

Re: Report Builder - Expression for background colors assistance

88Bronco2 — Fri, 21 Jun 2024 20:47:35 GMT

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!

Re: Report Builder - Expression for background colors assistance

88Bronco2 — Mon, 24 Jun 2024 15:27:09 GMT

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