SQL Server Reporting Services (SSRS) is a report generation software system of Microsoft in Server-Side. It is using to variety of interactive and useful reports. It is generated with the help of Login-Id and Pass on web based Interface. Its main is RS with the help of web based interface to support the development of custom reporting applications.
Parameters in Microsoft SQL Server 2000:
There are so many types of parameters but some of the most useful to know are:
1: Selecting all or one item from a list First Create a Data set to return @Parameter A: SELECT DISTINCT Name FROM Organization Name UNION SELECT '.All' AS Name ORDER BY A
Then the main data set add to the front IF @Parameter = '.All' SELECT And after the SQL, add ELSE and repeat the SQL
2: Selecting the hour and Minutes or hour, Minutes and seconds. For this a set of Datasets where one is filtered by the other, provides the final Parameters for your main data. Dataset Called Hour select distinct hour (date) as hour from Times order by 1 DESC Note how this is sorted in descending order. This is so the latest hour (parameter) is displayed. Also note, is one of the columns returned in another dataset is also hour, then reporting services will return an error. Change the name of the data set to fix this.
Reporting Services with Web Services:
The Reporting Services behalf of Web service is an Extensible Markup Language (XML) Web service with a Simple Object Access Protocol (SOAP) API.
If we will use the RS with web service so it improves the functionality of this services
to your business applications. Web Service interface provides a set of rendering and viewing functions during URL access, yet web based services also provides a additional functionality of managing the contents of a report server with the help of vital set of web methods.
In the case of reports management, subscriptions, schedules, data sources, and other Report Server items is a requirement.
For the Report server, web service provides a single entry point to the full functionality of Report managements. It is quite easy to develop applications that take advantage of the web services using Visual Studio.Net or any other SOAP-enabled development tools.
Benefits of SQL Server Reporting:
1: Create applications to manage one or more report servers through the Web services interface.
2: Create additional rendering, delivery, and data processing extensions using the Microsoft.NET Framework.
3: Create applications that generate reports using the Report Definition Language (RDL).
4: Create applications that embed or link to a Web browser to present and manipulate report output through URLs.