I am generating the pdf file out this code using 2 datatables of dataset, but, the data in pdf appearing from ds.Tables[0] only , not of ds.Tables[1].my code is as below . Kindly suggest solution...
ReportViewer viewer = new ReportViewer();
viewer.ProcessingMode = ProcessingMode.Local;
viewer.Reset();
viewer.LocalReport.ReportEmbeddedResource = @"D:\Projects\NIKHIL\NIKHIL\Report3.rdlc; viewer.LocalReport.ReportPath = @"D:\Projects\NIKHIL\NIKHIL\Report3.rdlc; viewer.LocalReport.DataSources.Clear();
viewer.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", ds.Tables[0])); viewer.LocalReport.DataSources.Add(new ReportDataSource("DataSet2", ds.Tables[1])); viewer.LocalReport.Refresh();
byteViewer = viewer.LocalReport.Render(reportType, deviceInfo, out mimeType, out encoding, out extension, out streamIds, out warnings);
return byteViewer;
AnandSG
0 Points
2 Posts
how to render the rdlc main report with multiple datasources from code behind in C#?
Jan 06, 2013 07:51 AM|LINK
I am generating the pdf file out this code using 2 datatables of dataset, but, the data in pdf appearing from ds.Tables[0] only , not of ds.Tables[1].my code is as below . Kindly suggest solution...
ReportViewer viewer = new ReportViewer(); viewer.ProcessingMode = ProcessingMode.Local; viewer.Reset(); viewer.LocalReport.ReportEmbeddedResource = @"D:\Projects\NIKHIL\NIKHIL\Report3.rdlc; viewer.LocalReport.ReportPath = @"D:\Projects\NIKHIL\NIKHIL\Report3.rdlc; viewer.LocalReport.DataSources.Clear(); viewer.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", ds.Tables[0])); viewer.LocalReport.DataSources.Add(new ReportDataSource("DataSet2", ds.Tables[1])); viewer.LocalReport.Refresh(); byteViewer = viewer.LocalReport.Render(reportType, deviceInfo, out mimeType, out encoding, out extension, out streamIds, out warnings); return byteViewer;