Geeks With Blogs
Bunch's Blog One day I'll have a catchy subtitle, one day

Expressions are something I have found to be very handy when using SSRS. A report I needed to setup had to list when a user had last visited a site. Since they needed to make a visit every three years the report listed the last visit date and the date three years out (this was all done is the stored procedure). Sometimes folks may get behind and I wanted to highlight the sites that were past due.

The report needed to be able to be sorted by a date, town or county so I could not just list the sites by date and have the overdue visits all at the top. I decided to simply have the overdue sites listed in bold. To accomplish this I added the following to the TableRow’s font weight property:

=iif (FORMAT(Fields!ThreeYearsOut.Value, "MM/dd/yyyy") < Today(), "Bold", "Normal")

Now when the report is generated the overdue sites are bolded and stick out a bit even when not sorted by date to begin with.


Technorati Tags:
Posted on Thursday, December 4, 2008 1:49 PM SSRS | Back to top

Comments on this post: Conditional SSRS Formatting

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Bunch | Powered by: