BY TOPIC▼
SQL SERVER BLOGS▼
SSRS BLOGS▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Blogs from Wise Owl on Expressions in SSRS
Showing blogs 1-3 (out of 3)
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.