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

What is SQL Reporting Services?

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

How do I create a report?

There are 2 common ways of creating a report for use by SQL Reporting Services. Reports in...

What do I need to do to sign up for SQL Reporting Services?

Contact sales@oissite.com and request a Reporting Services account today!

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....