Search

Showing posts with label reporting services. Show all posts
Showing posts with label reporting services. 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")

Friday, 8 October 2010

[SSRS] Adding simple STYLES to SSRS reports.

Adding simple STYLES to SQL SERVER REPORTING SERVICES reports.

"We are looking at is a simple and efficient way of changing the colour of cells,
text and lines, as well as changing the thickness and type of borders instantly
and globally for one or more reports, using a tagged, or named style approach."


  • Step1: Add EMBEDDED CODE to a report

  • Step2: Apply Styles to the relevent report properties ("BackgroundColour" = "=code.StyleColor("Header")")

  • Step3: Think of a naming convention for the different styles you need, and use these in reports.



  • http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/65810/