How to set parameter values in RDLC

DhavalR picture DhavalR · Jan 17, 2015 · Viewed 23.6k times · Source

I have added two text boxes for the date range in the report. To fill the values in the text boxes, I set parameters to the text boxes.

Now the date range is coming from a form named DateRange having two DateTimePickers.

How to set the value of the text boxes in rdlc equal to these DataTimePickers?

Answer

Shell picture Shell · Jan 17, 2015

You can set parameter value like this.

DateTime dtStartDate = dateTimePicker1.Value;     
DateTime dtEndDate = dateTimePicker2.Value;     
ReportParameter[] params = new ReportParameter[2]; 
params[0] = new ReportParameter("StartDate", dtStartDate, false); 
params[1] = new ReportParameter("EndDate", dtEndDate, false); 
this.ReportViewer1.ServerReport.SetParameters(params);

Passing Parameters to RDLC