[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 778
  • Last Modified:

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
0
Bruce
Asked:
Bruce
  • 2
1 Solution
 
BruceAuthor Commented:
Note:  I can "Preview Data" and get results in the XSD, dsReport->dtBusinessUnitCertEventListing->GetData().
0
 
Bob LearnedCommented:
1) You added a ReportDataSource.

2) You defined a typed DataSet.

3) Your DataSet is returning preview data.

4) Did you Fill the DataSet using a TableAdapter?
0
 
BruceAuthor Commented:
:-)  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!!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now