Thanks
FADUGBA JEREMIAH,I have crete RDLC runtime and save the xml code of dynamically generated rdlc in DetailReport.rdlc .Now my problem is on top of winform i have keep one ComboBox,from which i can select which data i have to display in report.For first selected item it display report,then after it doesn't show report.
My code is as follow:
![](/forums/uploadfile/510827/11252013081953am/customer.jpg)
![](/forums/uploadfile/510827/11252013081953am/EMployee.jpg)
private void btnShow_Click(object sender, EventArgs e)
{
ReportViewer1.Reset();
ReportViewer1.LocalReport.DataSources.Clear();
string dsName = comboBox1.Text;
#region SQL
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection("Data Source=SERVER;Initial Catalog=Test;User ID=sa;Password=sa");
SqlCommand cmd = new SqlCommand("SELECT * FROM dbo." + dsName, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
#endregion
ReportGenerator gen = new ReportGenerator(dt, dsName);
ds = new ReportDataSource(dsName, dt);
string xml = gen.GeneraReport();
XmlDocument xDoc = new XmlDocument();
xDoc.LoadXml(xml);
xDoc.Save(@"D:\\Surendra\\SSRS\\SSRS\\DetailReport.rdlc");
ReportViewer1.LocalReport.ReportEmbeddedResource = "SSRS.MainReport.rdlc";
ReportViewer1.LocalReport.DisplayName = "Main Report";
ReportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
this.ReportViewer1.RefreshReport();
}
void LocalReport_SubreportProcessing(object sender, SubreportProcessingEventArgs e)
{
if (e.ReportPath == "DetailReport")
e.DataSources.Add(ds);
}