SSRS Dynamically change the cell background and font color

reporting-services ssrs-2008 ssrs-tablix
goofyui picture goofyui · May 1, 2014 · Viewed 26k times · Source

I need to change the Table Cell Background color to Yellow and Font color to Bold / Red for values which are less than 80.

Cell Expression is =Fields!Mark.Value

How to change the Cell Background Color / Fill the Color to Yellow ?

Answer

Chris Latta picture Chris Latta · May 1, 2014

Nearly everything in SSRS is an expression, so you can use VBA code to conditionally set the property value.

To set the background colour, set the BackgroundColor property of the table cell to be:

=IIF(Fields!Mark.Value < 80, "Yellow", "White")

To set the font to bold, set the Font-FontWeight property of the table cell to be:

=IIF(Fields!Mark.Value < 80, "Bold", "Normal")

To make the text red, set the Color property of the table cell to be:

=IIF(Fields!Mark.Value < 80, "Red", "Black")

Related questions

SSRS How to repeat the table header on each page in print preview

I have an SSRS report, for some reason the header is not repeating on all of the pages in the print preview mode. Below is the image of the table: I have as well checked the Repeat Header rows on …

Read More
How to check if SSRS Textbox is empty

How do you check if a textbox is empty in SSRS 2008? I've tried this code and it doesn't work. IIF(ReportItems!txtCountVolunter.Value = "", false, true)

Read More
Is there an easy way to rearrange tablix columns in SSRS design mode?

I have an SSRS report which contains more than 20 columns in a tablix. Our users have decided that the data is OK, but they want the columns moved around (sigh!). It seems like it should be easy to re-arrange the …

Read More