Friday, June 1, 2012

Difference between MS SQL Server Reporting Services 2005 and 2008


SSRS 2005
SSRS 2008
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.
Don't Support html data fields It has HTML capability (can read data from html data fields)
It has less visualization components It has a very rich set of visualization components like Dials, Gauges, Sparklines etc.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.