Few of my colleagues and friends have been asking me for a while to write something on the differences between SQL Server Reporting Services versions 2005 and 2008. Especially when they were preparing for interviews / attending interviews, this was one of the most common questions they were asked by the interviewers. However when they browsed on the net, they could not get a comprehensive list of differences between SSRS 2005 and SSRS 2008 not even in a single place. Hence I came up with this idea of presenting some of the major differences between SSRS 2005 & 2008 so that it is helpful for the people who are curious to know about the differences between SSRS 2005 & 2008 and also for those people who are preparing for an interview on SQL Server Reporting Services.
Below table shows few of the differences between 2005 and 2008 versions of SQL Server Reporting Services in the order of priority (major to minor differences from top to bottom).
| SQL Server 2005 Reporting Services | SQL Server 2008 Reporting Services |
|---|---|
| Multiple service architecture (IIS Service & Windows Service) | Single service architecture (Windows Service) |
Depends on IIS | Comes with Built-In Web Server and hence does not depend on IIS |
Complex deployment due to the need for separate configuration for IIS | Deployment is simple due to inbuilt web server and Reporting Services Configuration Manager |
Charts, Dials etc. had to be separately installed and integrated | Comes packaged with Charts, Dials, Indicators, Sparklines etc. |
Limited exporting options | More exporting options including Microsoft Word etc |
You can only format entire text in a textbox with one single formatting style (bold, italicize, colors etc.) | Allows you to format pieces of text or words or letters within a single textbox with different formatting styles like bold, italicize, colors etc. Example: a Disclaimer Textbox, Header Textbox etc. |
Apart from this there are quite a few other differences or improvements in SQL Server 2008 Reporting Services. For more details, please see the Product Information Page for SQL Server 2008 Reporting Services.
This post is specially for Suneel who had asked for this quite long time back :-)
If there are any other major differences which are worth mentioning then do leave a comment, so that the post can be updated and other readers can benefit from it.
As always for any comments / suggestions / opinions, please leave a comment below.
Related Articles:
If there are any other major differences which are worth mentioning then do leave a comment, so that the post can be updated and other readers can benefit from it.
As always for any comments / suggestions / opinions, please leave a comment below.
Related Articles:
1 comments
fantestic datta...and nice to read this differnce and its help's people...
Post a Comment