I have a report that displays data based on date range: start date, and end date. These are the parameters fed to the dataset. Is there a way to intercept these parameters and feed them to the report?
Here is my code:
reportViewer1.LocalReport.DataSources.Clear();
ReportDataSource rds2 = new ReportDataSource("DataSet1", ods);
reportViewer1.LocalReport.DataSources.Add(rds2);
ods.SelectMethod = "GetTransactionByDateRange";
ods.TypeName = "ConsumablesTransactionLogBLL";
ods.SelectParameters.Add("sd", System.TypeCode.String, dateRange[0]);
ods.SelectParameters.Add("ed", System.TypeCode.String, dateRange[1]);
reportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/Consumables_By_Range.rdlc");
Thank you,
Risho
Create your parameters and bind them to the report
Microsoft.Reporting.WebForms.ReportParameter sd = new Microsoft.Reporting.WebForms.ReportParameter("sd",dateRange[0]);
Microsoft.Reporting.WebForms.ReportParameter ed = new Microsoft.Reporting.WebForms.ReportParameter("ed",dateRange[1]);
reportViewer1.LocalReport.SetParameters(new ReportParameter[] { sd, ed}});
In the RDLC you need to set up the parameters in the ReportData window to match the names.