Solved

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

Posted on 2009-05-11
3
753 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
Comment Utility
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
Comment Utility
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
Comment Utility
:-)  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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

744 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now