Search

Showing posts with label tip. Show all posts
Showing posts with label tip. Show all posts

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