THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

Developing a customized reporting solution based on SSRS

TeoLachevSession I just attended the session named "Applied Microsoft SQL Server 2005 Reporting Services" held by of Teo Lachev . Teo developed a complex solution that allow an end user to build its own reports with financial data, using Reporting Services as a back-end engine but defining its own custom report designer. While someone may object that there is not so much flexibility in report definition with this solution (you have several constraint in report designer), it could be appreciated by the many existing users that only want to say what data want to see into a report, while they didn't care much about possible layout customization. In reality the report looks very good for that kind of users.

The interesting part is that Teo developed an object model to abstract the underlying RDL that simpliefies an application that needs to deal with such a format. That model persist RDL through XML serialization and (as Teo hope) it would be useful if Microsoft would publish an "official" object model upon RDL.

Teo also showed other techniques he used in his solution, like retrieving data using CLR stored procedures, subclassing Report Viewer control to implement best practices and rules and finally how to extend reports with custom code (i.e. to use particular formats for numeric values based on locale of the user executing the report instead than a fixed format defined for the report - not a usual case, but if you need it... it's useful to centralize all that logic in a single assembly).

It's interesting to see a completely different approach like this using Reporting Services 2005.

Published Monday, June 04, 2007 5:56 PM by Marco Russo (SQLBI)
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog

Syndication

Archives

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement