SSRS vs CR
I have to give a presentation on SSRS which I had prepared but some questions still remain which are: Why should one choose SSRS over CR? What are its advantages over CR? Was there any type of reporting services before SSRS in SQL Server? Please tell me.
October 27th, 2010 9:35am
I cant answer about CR, but I can say there was no reporting capabilties in SQL Server before SSRS. Before that a lot of people used MS Access which has report\forms in it. Some used it as a front end to a SQL Server.
October 27th, 2010 9:58am
Every reporting tool has its own Pros and cons. As fas as i know SSRS comes free if you have SQL Server. MS Access
October 27th, 2010 10:15am
Quite an old article but worth a read http://www.crystalreportsbook.com/SSRSandCR_ExecSummary.aspmy blog http://karlberan.wordpress.com/
October 27th, 2010 10:42am
You will find important feature information on SSRS 2008 at the following link: Overview Microsoft SQL Server 2008 R2 Reporting Services provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise. Top New Features “Grab and Go” reporting experience enabled through the Report Part Gallery Support for maps and geospatial visualizations with integration to Bing maps and support for SQL spatial data types Additional visualizations including indicators, sparklines and data bars Support for consuming SharePoint lists and PowerPivot models as data sources Support for Madison and SQL Azure data sources Render any report as a data source to PowerPivot or other applications through ATOM data feeds Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM
October 27th, 2010 10:47am
Hi, Every produce has its advantages and disadvantages, below are some good points in SSRS, however these does not cover the whole advantages of SSRS: 1. Embedding .NET assembly is possible 2. Easily deployable as a package. 3. It supports more export file formats. They are Excel, Text, XML, PDF, TIFF, and MHTML. 4. Query design has more options. 5. It supports N-level of sub reports 6. Support Cascading Parameters 7. Support varied datasource. 8. Report model could supply friendly report design without having to have a knowledge of the table structures, field names, business rules and joins 9. Connecting to an analysis service is possible. 10. Linking reports by URL is possible. 11. Toggle/Collapse behavior exists in matrix control. Thanks, Challen Fu
November 2nd, 2010 4:21am