Friday, 20 February 2015

SQL SERVER Reporting Services Conditional Formatting trick to format colour

Here's a handy hint / tip for SSRS (sql server reporting services) to quickly reference the current cell.
Me.Value

We can use this "trick" to then quickly handle cell / font formatting.

=IIF(Me.Value < 0,"IndianRed","DarkSeaGreen")

This will be a great time saver, as it'll mean you don't have to lookup the cell name each time you want to perform a conditional format.
eg.
=IIF(ReportItems!Textbox1.Value <0, "IndianRed","DarkSeaGreen")

No comments:

Post a Comment