Difference between revisions of "MS SQL Reporting Services"
(New page: Microsoft SQL Reporting Services is a free add-on to MS SQL Server. It was first introduced for SQL Server 2000 as an additional install CD. With SQL Server 2005, it is now included as a...) |
|||
| Line 1: | Line 1: | ||
| − | Microsoft SQL Reporting Services is a free add-on to MS SQL Server. It was first introduced for SQL Server 2000 as an additional install CD. With SQL Server 2005, it is now included as an option during a typical install. If it is installed on an existing SQL Server machine, then the only additional cost is for one or more copies of Visual Studio, the development environment for creating the reports. | + | Microsoft SQL Reporting Services (SRS) is a free add-on to MS SQL Server. It was first introduced for SQL Server 2000 as an additional install CD. With SQL Server 2005, it is now included as an option during a typical install. If it is installed on an existing SQL Server machine, then the only additional cost is for one or more copies of Visual Studio, the development environment for creating the reports. |
| + | |||
| + | In many aspects, developing reports in SRS is like developing reports in MS Access. The interface is similar. The underlying programming capabilities is similar. But where SRS really shines is on the server side. After creating a report in Visual Studio, the report is published to the SRS server. That report is now available via the reporting web interface or via any application that makes the correct call to the SRS server. From the web interface, users can either run the reports interactively, or schedule to have a report delivered via email on a recurring basis. | ||
| + | |||
| + | Starting with SQL Server 2005, SRS includes an ad-hoc reporting feature in the web interface. A relationships in complex database schema are modeled in the reporting tool to allow end users to quickly create their own reports without having to completely understand the underlying database. | ||
Revision as of 06:05, 23 February 2008
Microsoft SQL Reporting Services (SRS) is a free add-on to MS SQL Server. It was first introduced for SQL Server 2000 as an additional install CD. With SQL Server 2005, it is now included as an option during a typical install. If it is installed on an existing SQL Server machine, then the only additional cost is for one or more copies of Visual Studio, the development environment for creating the reports.
In many aspects, developing reports in SRS is like developing reports in MS Access. The interface is similar. The underlying programming capabilities is similar. But where SRS really shines is on the server side. After creating a report in Visual Studio, the report is published to the SRS server. That report is now available via the reporting web interface or via any application that makes the correct call to the SRS server. From the web interface, users can either run the reports interactively, or schedule to have a report delivered via email on a recurring basis.
Starting with SQL Server 2005, SRS includes an ad-hoc reporting feature in the web interface. A relationships in complex database schema are modeled in the reporting tool to allow end users to quickly create their own reports without having to completely understand the underlying database.
