Solved

Calling SQL Server 2005 Reports WebServices from ASP.Net app

Posted on 2007-03-28
2
887 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
grab and show facebook pages event calendars 6 65
dynamic menu in asp.net c# 11 57
Why is "packages element is not declared"? 2 124
Jquery autocomplete 10 68
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

919 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now