- The SQL Reporting Services product available with your account offers web service that allows you to create, run, and view reports programmatically. The Reporting Services web server will allow you to render a report that is deployed on a report server to a supported file format, such as the .pdf file format and open the rendered report on a Web page without saving the file that corresponds to the rendered report on your computer. This article will provide step-by-step instructions on how to make use of the Reporting Services Web Service, http://support.microsoft.com/?kbid=875447 .
- To consume the web service, simply reference the service at https://ssrs.oissite.com/reportserver/reportservice.asmx
- For more information about consuming and implementing the SQL Reporting Services web service, consult the SQL Reporting Services Books Online.
- Once you've added a reference to the Web Service within your application, the command below will pass your login credentials to the Report Server and will not prompt website visitors for a username and password:
rs.Credentials = New System.Net.NetworkCredential (username, password) - For more information on SQL Reporting Services Web Service refer to:
• http://msdn.microsoft.com/library/default.asp
• SQL Reporting Services Books Online
• A step-by-step article on referencing SQL Reporting Services Web Service, http://support.microsoft.com/?kbid=875447
- 0 Users Found This Useful