Generate RDLC report using LINQ

my database structure is like

ID, DESCRIPTION, VALUE

when I try to generate the RDLC report I do

My Code:

private void load_profile_btn_Click(object sender, EventArgs e)
{
historicalData_gb.Visible = false;
DataSet1TableAdapters.Load_ProfileTableAdapter tb4 = new DataSet1TableAdapters.Load_ProfileTableAdapter();
DataSet1.Load_ProfileDataTable ds = tb4.GetData();
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource4 = new Microsoft.Reporting.WinForms.ReportDataSource("Load_Profile", ds.AsEnumerable().CopyToDataTable());
reportViewer1.LocalReport.DataSources.Clear();
reportViewer1.LocalReport.DisplayName = "Load Profile";
reportViewer1.LocalReport.ReportPath = @"C:\Users\SalmanMushtaq\documents\visual studio 2013\Projects\Sec_Report_Rdlc\Sec_Report_Rdlc\load_profile.rdlc";
reportViewer1.LocalReport.DataSources.Add(reportDataSource4);
reportViewer1.RefreshReport();
}

Now the report will appear like

ID, DESCRIPTION, VALUE

But I need to show the report like DESCRIPTION have 3 kind of entry i.e. P1,P2,P3 so I need to show like ID, P1, P2, P3, VALUE

For this I add Model "Linq to Sql" and now I need to show the report as I explain above. Please help.

You need to bind Dataset dynamically to rdlc report.

https://nithuan.wordpress.com/2012/07/27/adding-report-datasource-on-runtime-to-a-rdlc-file-on-reportviewer/

https://forums.asp.net/t/1681823.aspx?Creating+Dataset+Dynamically+in+c+and+passing+to+Report+Viewer+

https://blogs.msdn.microsoft.com/sqlforum/2011/04/27/walkthrough-assign-dataset-dynamically-created-in-code-to-your-local-report-with-reportviewer/

https://www.codeproject.com/Tips/888174/Dynamically-Creating-an-RDLC-Report-Just-Using-a-D

1 Reply

Know the answer? Post it — somebody with the same question will find it here.