?
Solved

Calling SQL Server 2005 Reports WebServices from ASP.Net app

Posted on 2007-03-28
2
Medium Priority
?
931 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 20

Accepted Solution

by:
brwwiggins earned 1000 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
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.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

771 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