Solved

Calling SQL Server 2005 Reports WebServices from ASP.Net app

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

726 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