ASP.NET 4.0 SSRS 2008 reportviewer control not show data in ASPX page
I'm trying to show a SSRS 2008 report (.rdl) in a asp.net web page using the ReportViewer control (VS2010). The report show up well in browser when I test it in VS 2010 enviroment, but when I try to access the aspx page in production it only show the reportviewer toolbar with no data. User validation and parametesrs are fine because I can see these parameters values in the report if I turn ShowParameterPrompts property to true. ANY HELP will be appreciated !!! Here is my C# code for the page. reportviewer control name = rpvExportacion: protected void Page_Init(object sender, EventArgs e) { ScriptManager1.EnablePartialRendering = false; } protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Reporte('01','2012') } } protected void Reporte(string Cia, string Ano) { rpvExportacion.Visible = true; rpvExportacion.ProcessingMode = ProcessingMode.Remote; IReportServerCredentials irsc = new CustomReportCredentials("Administrator", "reveex1*", "REVEEX"); rpvExportacion.ServerReport.ReportServerCredentials = irsc; rpvExportacion.ServerReport.ReportServerUrl = new System.Uri(ConfigurationManager.AppSettings["ReportServer"].ToString()); rpvExportacion.ServerReport.ReportServerUrl = new System.Uri("Http://AD/ReportServer"); rpvExportacion.ServerReport.ReportPath = "/REVEEXreports/VentasExportacion"; ReportParameter[] Param = new ReportParameter[2]; Param[0] = new ReportParameter("Cia", Cia); Param[1] = new ReportParameter("Ano", Ano); rpvExportacion.ServerReport.SetParameters(new ReportParameter[] { Param[0] }); rpvExportacion.ServerReport.SetParameters(new ReportParameter[] { Param[1] }); rpvExportacion.SizeToReportContent =true; } public class CustomReportCredentials : IReportServerCredentials { private string _UserName; private string _PassWord; private string _DomainName; public CustomReportCredentials(string UserName, string PassWord, string DomainName) { _UserName = UserName; _PassWord = PassWord; _DomainName = DomainName; } public System.Security.Principal.WindowsIdentity ImpersonationUser { get { return null; } } public ICredentials NetworkCredentials { get { return new NetworkCredential(_UserName, _PassWord, _DomainName); } } public bool GetFormsCredentials(out Cookie authCookie, out string user, out string password, out string authority) { authCookie = null; user = password = authority = null; return false; } }
June 10th, 2012 11:17pm

It may be the problem in the communication between your Report Server and Web Server. Try to open the report from your web server directly in the browser.
Free Windows Admin Tool Kit Click here and download it now
June 11th, 2012 2:11am

The report can be open everywhere except inside the aspx page. I can open it through http://AD/repots/VentasExportacion at any PC of the network. As I mention even in the internal test webserver in VS2010 can be open. Any suggestion ?. Thank you in advance, Rafael
June 11th, 2012 10:17am

I means in the internal VS2010 webserber I can open the aspx page with the report and it works. But when I open the aspx page in our production webserver (IIS 7), it doesn't work. Only show the reportviewer toolbar and the rest is empty.. :-(
Free Windows Admin Tool Kit Click here and download it now
June 11th, 2012 1:41pm

Any help please ?. Why does the report using the reportviewer control works perfectly if I test it with the VS2010 internat website, and when I run the page in the main (production) web site does not work ? What is the diference between this two web servers ? HELP !
June 21st, 2012 6:38pm

It may be a double hop issue. This post may help you to solve the problem. http://dotnetrobert.com/?q=node/36
Free Windows Admin Tool Kit Click here and download it now
June 23rd, 2012 6:24pm

Hi Irusul, thank you for try to help me !. I did what the article say, but unfortunately doesn't work. No change at all. I've no errors , no nothing !. The reportviewer control appear in blank. Here it's a screenshot of one of the reports. Parameters are fine. It works fine using VS2010 internal web server and it works fine if I call the report by the ssrs direct site. But when I use reportviewer to display the report inside a aspx webpage, this is the result !
June 25th, 2012 9:44pm

Hello. This is an information of the people who is reading this thread, I finally gave up. I've passed the parameters to a new windows browser in which the report is open, but I couldn't find the way to present the report inside an ASPX page using ReportViewer10. :-(
Free Windows Admin Tool Kit Click here and download it now
August 27th, 2012 3:25pm

I bet it is a permission issue. You should make sure the SECURITY PRINCIPLE that runs your aspx application has access to read reportsRobert Attaway The SQLMDX Dude sqlmdxdude@gmail.com
August 28th, 2012 3:08pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics