I have a web application in asp.net 3.5 published in apps server.I have few SSRS reports deployed in a database server which needed to be accessed from the web app.Both the server are in same network.I am using a report viewer control to show the reports and i am passing the report path dynamically.I am also sending the login credentials from code behind.
The problem is that the report is identified correctly and the proper report parameter are also shown.But when i click the view report button no data appears.I have Sql server 2008 r2 and report viewer version 9.0
Please help me with this. here is a code snippet...
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ReportViewer1.ShowCredentialPrompts = false;
IReportServerCredentials irsc =
new CustomReportCredentials("user", "pass", "domain");
ReportViewer1.ServerReport.ReportServerCredentials = irsc;
ReportViewer1.ServerReport.ReportServerUrl =
new Uri("http://72.0.170.205:80/ReportServer");
ReportViewer1.ShowParameterPrompts = true;
ReportViewer1.ShowPrintButton = true;
ReportViewer1.ProcessingMode = ProcessingMode.Remote;
ReportViewer1.ServerReport.Refresh();
ReportViewer1.ServerReport.ReportPath = Request.QueryString["val"];
}
}
Did you check that the reports run ok with the same credentials on http://72.0.170.205:80/Reports ?
Don't know if this can be of any help but here are the differences I see in my implementation :
my reportDisplay application is not the root app. Because of conflicts, back in SSRS2005 I had to use a different name for its session cookie in the web.config. Kept it since then
<sessionState cookieless="UseCookies" cookieName="ASP.NET_SessionId.myCustomName"/>