Dynamically Load Embedded Resource Report Using Microsoft.Reporting.WinForms

c# reporting-services report
Craig Eddy picture Craig Eddy · Oct 2, 2008 · Viewed 20k times · Source

How does one dynamically load a new report from an embedded resource? I have created a reporting project that contains a report as an embedded resource. I added a second report file and use the following code to switch reports:

this.reportViewer1.LocalReport.ReportEmbeddedResource = "ReportsApplication2.Report2.rdlc";
this.reportViewer1.LocalReport.Refresh();
this.reportViewer1.RefreshReport();

When this code executes, the original report remains visible in the report viewer.

I have also tried using

LocalReport.LoadReportDefinition

but had the same result.

Answer

Craig Eddy picture Craig Eddy · Oct 3, 2008

The answer: you have to call 

<ReportViewer>.Reset();

prior to changing the value of ReportEmbeddedResource or calling LoadReportDefinition.

After you do so, you'll also have to call 

<ReportViewer>.LocalReport.DataSources.Add( ... );

to re-establish the data sources.

Related questions

.rdlc Report - Cannot create a data reader for dataset 'DataSet1'

I have created a .rdlc-Report under VS 2012 using the report wizard and added data source and dataset. When I try to render the report using the code below I get following error message: Cannot create a data reader for dataset …

Read More
SSRS: Master-detail report with two datasources

I have two local data sources that I can push into the report. Works no problem. But how do I set up the report? One data source contains a list of employees, and info about them. The other contains a …

Read More
Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=11.0.0.0

I recently upgraded my n-tier solution from .NET 3.5 vs 2008 to 4.5 visual studio 2012. Every thing went fine apart from crystal reports and I had to install new runtime crystal reports for visual studio 2012 from the following link http://downloads.businessobjects.com/…

Read More