Crystal Report ParameterFields
-
i wrote a sales report, which works fine with my application if i include start date and end date in the database, {gndsale.dob} in {date.startdate} to {date.enddate}. but if i change the report to pass Parameter Fields, {gndsale.dob} in {?Start Date} to {?End Date} when i load the report first time it's okay i can see the correct parameters on the Page header and in Details, but if i load report 2nd time with different parameters , the page header is updated but the details not, some how i need to refresh crystalReportViewer1 after i pass parameters. ??? check this code ReportDocument1.Load(RptPath.ToString()); crystalReportViewer1.RefreshReport(); crystalReportViewer1.ReportSource = reportDocument1; paramFields = new ParameterFields (); ParameterField crParamFld = new ParameterField(); ParameterDiscreteValue CrparamValue = new ParameterDiscreteValue(); paramFields = crystalReportViewer1.ParameterFieldInfo; crParamFld = paramFields[0]; CrparamValue.Value = PassDT_Start; crParamFld.CurrentValues.Add(CrparamValue); ParameterField crParamFld_2 = new ParameterField(); ParameterDiscreteValue CrparamValue_2 = new ParameterDiscreteValue(); crParamFld_2 = paramFields[1]; CrparamValue_2.Value = PassDT_End; crParamFld_2.CurrentValues.Add(CrparamValue_2); crystalReportViewer1.ParameterFieldInfo = paramFields; crystalReportViewer1.ReportSource = reportDocument1; Or this code reportDocument1.SetParameterValue("Start Date",PassDT_Start ); reportDocument1.SetParameterValue("End Date",PassDT_End ); crystalReportViewer1.RefreshReport(); crystalReportViewer1.ReportSource = reportDocument1;