Thursday, March 26, 2009

Reporting Services Styles & Templates

Reporting Services Styles in a Database Table

This article is about storing colors for headers, footers and body text in the database and using the DataSet to store at the top level report and passing down to subreports through parameters.

Reporting Services Styles in a Database Table - SQLServerCentral

Create Report Template

This article describes how to create a template you can use to maintain your company template starting point.  Logo, Header, footer, date, page counters etc.

How To Create Templates in Reporting Services 2005

Friday, March 6, 2009

Passing Multi-Value Parameters to Subreports

When passing a multi-value parameter using the Expression Builder it will automatically add the Parameter!Name.Value(0).  If you strip the (0) then it will work.  This expression returns the first selected value. 

Parameter passing from master to subreport : SQL Server Reporting Services : SQL Server : MSDN Forums

Tuesday, March 3, 2009

Scalar Function Performance...

I found this article which describes Scalar Functions acting as cursors.  Use the Table-Inline Function instead.  Adam found that it was 288 times better in IO.  Read article to understand the difference.

Adam Machanic : Scalar functions, inlining, and performance: An entertaining title for a boring post