How do I reference SQL Reporting Services in my own web application?

  • 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
Was this answer helpful?

Related Articles

How do I publish or deploy my report?

The Report Manager Web interface. You can upload your report file (.rdl) and data source file...

How do I get a copy of Report Designer?

To gain access to Report Designer, you must have a license for SQL Server and Visual Studio....

How can I get more information on SQL Reporting Services?

There are many resources available for SQL Reporting Services, but SQL Reporting Services Books...

What is SQL Reporting Services?

Microsoft® SQL Server™ 2005 Reporting Services is a new server-based reporting platform...

What databases/data-sources can be used for SQL Reporting Services?

Almost any database/data-source can be used with SQL Reporting Services, including Oracle....