Geek Answers Handbook

What is SQL Server Reporting Services?

Can someone explain to me about SQL Server Reporting and use it in ASP.net?

As a rule, I develop my reports in Crystal Report, assign a data source to the crystal report, creating my report.

What are the benefits of using SQL Server Reporting and how to use it?

+6
sql-server-2005 reporting-services
source share
4 answers

SQL Server Reporting Services (SSRS) are competitors to Crystal Reports. This is a way to define reports, like Crystal Reports, and a mechanism to run these reports.

SSRS itself is the website that hosts these reports and can serve their users via the web interface or schedule their delivery by email.

As a programmer, I prefer SSRS over Crystal, because of many others, in that it is more stable and uses an XML-based report file format, unlike the old old Crystal binary format. This means that some design tasks can be accomplished simply by editing XML, if it comes down to it.

+11
source share

Read all about this in SQL Server Books Online .

This is more or less the same as Crystal Reports, the reporting engine and designer. SSRS has some advantages over Crystal: it is server based, for example. you can process and process your reports on the server (for example, in the night schedule and distribute them by e-mail or something else), but also allows local execution of reports.

Due to the fact that this is a Microsoft product, it is more closely integrated with SQL Server and Windows than with Crystal Reports.

And if you have a valid SQL Server license, you have Reporting Services, a free add-on to SQL Server.

+2
source share

This is a reporting solution offered by Microsoft. You enable it if you have an MS SQL server license. Wiki gives more detailed information: http://en.wikipedia.org/wiki/SQL_Server_Reporting_Services

And here is additional information from Microsoft: http://www.microsoft.com/sqlserver/2008/en/us/reporting.aspx

Basically, you install report server software that runs a website and web services, which you can then use to host reports. The reports themselves are created using Visual Studio and are pretty easy to create. Having said that, you can make very complex reports using several queries and scripts.

As Dave noted, he got pretty good integration with the whole Microsoft Stack.

HTH, Lance

+1
source share

This link is useful and explains how to use it http://www.simple-talk.com/sql/reporting-services/beginning-sql-server-2005-reporting-services-part-1/

+1
source share

More articles:


All Articles