I am using the Report Viewer control : <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" Height="400px" ProcessingMode="Remote" Width="400px"> <ServerReport ReportPath="https://servername/Reports/Pages/Report.aspx?ItemPath=%2flovelyjubbl%2fReports%2fQBRatings" ReportServerUrl="https://servername/reports/Pages/Folder.aspx" /> </rsweb:ReportViewer> But I get the following error : 'The request failed with HTTP status 401 : unauthorized' How do I prevent this error? Thanks, Mike
This error looks like a authentication issue. Can you post the code? (the .vb / .cs file) Bruce DiscountASP.NET www.DiscountASP.NET Post Edited (bruce [DASP]) : 5/21/2007 7:57:33 PM GMT
When you use Remote Processing, you'll need to programatically pass your report server credential. This post on MSDN may helphttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=884527&SiteID=1 Bruce DiscountASP.NET www.DiscountASP.NET
There is no code behind, I was advised by yourselves to use the Report Viewer for all SQL RS 2005 reports, so I have just dragged and dropped the control.
ReportViewer Control ------------------------- Report Viewer Control with MS SQL 2005 Reporting Service --------------------------------------------------------------------- Sample : daspstaff00.web120.discountasp.net/Report/default.aspx Sample Source Code: Click here In the web.config, set the values under [appSettings] for the following: 1>ReportingService Username [ReportingServiceUser] 2>ReportingService Password [ReportingServicePassword] 3>ReportingService Domain [ReportingServiceDomain] Notes: ------- ReportViewer Control: ------------------------ --ReportPath/ReportServerUrl under (ReportViewer control>ServerReport) will be as follows: ReportPath='/ [DASP_UserName] /reports/ [YourReportName]' ReportServerUrl='https://rs2k501.discountasp.net/ReportServer' --Custom class implementing the IReportServerCredentials Interface is required to provide credentials for connecting to the Reporting server. (See: http://msdn2.microsoft.com/en-US/library/microsoft.reporting.webforms.ireportservercredentials (VS.80).aspx) Vikram DiscountASP.NET www.DiscountASP.NET Post Edited (vvsharma) : 5/23/2007 10:38:04 AM GMT