Solved

Calling SQL Server 2005 Reports WebServices from ASP.Net app

Posted on 2007-03-28
2
874 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
Comment Utility
0
 

Author Comment

by:aspnetdev
Comment Utility
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
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.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

763 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

9 Experts available now in Live!

Get 1:1 Help Now