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.
Related Articles
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:
- Features of SQL Server Reporting Services (SSRS)
- Shortcuts for SQL Server Client Applications
- Controlling Exporting Options in Reporting Services (SSRS)
- How to Display Report Execution Time in Reporting Services (SSRS)
- Other SSRS Related Articles on MyTechnoBook
This post first appeared on MyTechnoBook - Datta's Technical Notes..!!, please read the originial post: here
