Background color change in SSRS

reporting-services

I'm trying to Highlight the row for 'Major group' and its 'subgroup' row in my report. where I have to change the background color of the row depending on the string value in the cell.

Ex: if the column has a value 'MG' in it, the cell should show a 'SomeColor, say Green' background color. I tried the following:

=IIF(Fields!ProductGroup.Value = "MG", "Green", "No Color")

tried

=Switch(Fields!ProductGroup.Value = "MG", "DarkViolet", Fields!ProductGroup.Value="SG","Gold")

Nothing is working for me. What am I missing?

Best Answer

If you are using SSRS 2008 or SSRS 2008 R2 Service Release 0 or earlier, No Color and Transparent are 8 digit hex codes ("#FFFFFFFF"), But Background Colors only support 6 digit Hex codes ("#FFFFFF"). The extra two bits are Transparency level and are not supported for Background Colors. You need to use Nothing instead to prevent warnings. I believe this has been fixed in SSRS 2012.

Related Solutions

SSRS Field Expression to change the background color of the Cell

The problem with IIF(Fields!column.Value = "Approved", "Green") is that you are missing the third parameter. The correct syntax is IIF( [some boolean expression], [result if boolean expression is true], [result if boolean is false])

Try this

=IIF(Fields!Column.Value = "Approved", "Green", "No Color")

Here is a list of expression examples Expression Examples in Reporting Services

IIF in SSRS report

Change color depending on value SSRS

You defined an expression for the value of the TextBox, which isn't what you want. Simply display the value in the TextBox like you would for any other cell.

You should define an expression in the TextBox Fill or Fontproperties. Depending on what exactly you wish to color.

As an example I'll show you how to change the background color.

You can navigate to the above menu by rightclicking the cell and selecting "Text Box Properties...". Then simply define the same expression for Fill color

=SWITCH(Fields!System.Value < 70, "Red", Fields!System.Value > 70, "Yellow", Fields!System.Value >= 85, "Green")

Best Answer

Related Solutions

SSRS Field Expression to change the background color of the Cell

Change color depending on value SSRS

Related Topic