Reporting Services talk at SQL Server User Group

At the SQL Sever user group in Reading this week, I gave a presentation on Reporting Services. I met a great bunch of attendees and there were some very interesting questions raised at the session.

The first one was a question on how you would go about deploying a report onto (for example) 100 Report Servers.

Having looked into this a little, Reporting Services includes a utility called RS.Exe which can be used to help automate tasks. The following site on Codeplex contains sample script using RS.exe that performs the deployment of RDL Report files.

http://msftrsprodsamples.codeplex.com/wikipage?title=SS2008!Script%20Samples%20%28Reporting%20Services%29

The second question was whether or not there was any mechanism for consistently applying styles against reports in a similar way in which CSS can be used to apply styles to HTML.

A member of the audience suggested an innovative approach of saving the styles in a database and using expressions to retrieve them. More details can be found on the Simple Talk site here:

http://www.simple-talk.com/sql/reporting-services/reporting-services-with-style/

For anyone interested, my slides for the presentation can be found here.

Technorati Tags:

Advertisements

About dotnettim

Tim Leung is a Microsoft .Net / SQL Server developer based in England.
This entry was posted in SQL Server 2008. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s