Blogs from Wise Owl on Expressions in SSRS

Differences between SSRS 2008 R2 and 2012 for Excel render format

Posted by Andy Brown on 17 June 2013

This blog shows how to conditionally hide, display or format parts of a report according to its render format (ie whether you're viewing it in Excel or not). The method used is slightly different between 2008 R2 and 2012.

Two ways to create alternating colours in SSRS

Posted by Andy Brown on 03 August 2012

A common requirement for Reporting Services reports is to colour alternate rows. This blog gives two approaches, one of which uses custom assemblies.

Exporting SSRS Reports to Excel using RenderFormat

Posted by Andy Brown on 25 July 2011

SQL Server Reporting Services 2008 R2 includes (among many other features) the ability to detect a report's rendering format, together with a facility for naming report pages. You can combine these two features to create Excel workbooks with individually named worksheets for each member of a group, as shown in this blog.