- 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.