Difference between SSRS 2005 and SSRS 2008
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.|
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.