asked on

Why is my SSRS/RDLC report, in my ReportViewer Control, not filled with data?

Report shows without error. All the table header and none data connected Textboxes text shows.

The ReportViewer control sits alone on an ASP.net page (it does have a master page).
Here are the steps I take in the Page_Load:
-Instantiate my XSD derived DataTables
-Instantiate a ReportDataSource with the above table referenced
-Call Add on the DataSources collection of the ReportViewer.LocalReport with the new ReportDataSource
-Set the ReportPath of the ReportViewer.LocalReport

I have checked to see that my Table control has been attached to the only DataSource in the report.

I've checked the datatable prior to leaving the Page_Load function. It is not populated. Should it be?

dsReport.dtBUEventListingDataTable dtBUEventListing = new                 
dsReport.dtBUEventListingDataTable();                
 
reportDataSource = new ReportDataSource("dsReport_dtBusinessUnitCertEventListing", dtBUEventListing);
 
mapPath = "~/webforms/Certification/Reports/CertificationEventStatistics.rdlc";
 
ReportViewer1.LocalReport.DataSources.Add(reportDataSource);
        ReportViewer1.LocalReport.ReportPath = Server.MapPath(mapPath);

Open in new window

EmptyReport.PNG
CertEventStats-Report-Designer.PNG
CertEventStats-Report-Designer-P.PNG

Bruce

ASKER

Note: I can "Preview Data" and get results in the XSD, dsReport->dtBusinessUnitCertEventListing->GetData().

ASKER CERTIFIED SOLUTION

Bob Learned

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bruce

ASKER

:-) No. I hadn't until yesterday. I found another SSRS/RDLC question on the EE site and implemented it.

My problem started with an example where there was one report with several ReportDataSources. The example only filled the first ReportDataSource and the others must have been filled magically by the report parameter. I don't know how that one works but it does work in the app I am using now.

Either way the solution was to make sure my DataSet was populated before the page was rendered.

Thanks!!