Solved

Calling SQL Server 2005 Reports WebServices from ASP.Net app

Posted on 2007-03-28
2
900 Views
Last Modified: 2008-02-01
Hi,
I have created few reports using the SSRS,now i want to access these reports using the web services..
also i have to pass the parameters to these reports from my UI.I created following method in my Code behind and im setting all the credentials in my web.config file

private ReportingService2005 GetReportingService()
{
   ReportingService2005 rs = new ReportingService2005();
   String userName = ConfigurationSettings.AppSettings["ReportingServices2005.Credentials.Username"];
   String password = ConfigurationSettings.AppSettings["ReportingServices2005.Credentials.Password"];
   rs.Credentials = new NetworkCredential(userName, password);
   return rs;
}

i have  3 drop downs in my UI and a button .When the button is clicked i have to get the values from the ddl's and select report accordingly ..as user will be selecting the report name from ddl too....and then open the report in pdf format....can any one help on this....\
Thanks,
0
Comment
Question by:aspnetdev
2 Comments
 
LVL 20

Accepted Solution

by:
brwwiggins earned 250 total points
ID: 18810736
0
 

Author Comment

by:aspnetdev
ID: 18826131
That link does not help much ....i get this error
System.InvalidOperationException: Client found response content type of 'text/html', but expected 'text/xml'. The request failed with the error message: -- The specified procedure could not be found. --. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Web.ReportExecution2005.ReportExecutionService.LoadReport(String Report, String HistoryID)
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question