Solved

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

Posted on 2009-05-11
3
758 Views
Last Modified: 2013-12-17
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
Comment
Question by:Bruce
  • 2
3 Comments
 
LVL 1

Author Comment

by:Bruce
ID: 24355563
Note:  I can "Preview Data" and get results in the XSD, dsReport->dtBusinessUnitCertEventListing->GetData().
0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
ID: 24363298
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
 
LVL 1

Author Closing Comment

by:Bruce
ID: 31580165
:-)  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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question