
problem passing parameters to crystal reports
I'm trying to display some
Crystal Reports used by the customer
service dept. in a web application. If the report has no parameters,
the report shows up just fine using CrystalReportViewer. However,
when I try to assign values to a parameter based report, i get the
error "Missing parameter field current value."
This is my first time working with Crystal Reports in ASP or ASP.Net,
so I'm not sure if i'm on the right track or way out in right field...
my code is below....any help/insight would be appreciated. Reply to
if(Page.IsPostBack)
{
ParameterField param1 = new ParameterField();
ParameterField param2 = new ParameterField();
ParameterField param3 = new ParameterField();
ParameterField param4 = new ParameterField();
param1.ParameterFieldName = "StartDate";
param2.ParameterFieldName = "EndDate";
param3.ParameterFieldName = "StartUser";
param4.ParameterFieldName = "EndUser";
ParameterDiscreteValue param1Val = new ParameterDiscreteValue();
ParameterDiscreteValue param2Val = new ParameterDiscreteValue();
ParameterDiscreteValue param3Val = new ParameterDiscreteValue();
ParameterDiscreteValue param4Val = new ParameterDiscreteValue();
param1Val.Value = startDate.Text;
param2Val.Value = endDate.Text;
param3Val.Value = startUser.Text;
param4Val.Value = endUser.Text;
param1.CurrentValues.Add(param1Val);
param2.CurrentValues.Add(param2Val);
param3.CurrentValues.Add(param3Val);
param4.CurrentValues.Add(param4Val);
ParameterFields paramFields = new ParameterFields();
paramFields.Add(param1);
paramFields.Add(param2);
paramFields.Add(param3);
paramFields.Add(param4);
CrystalReportViewer1.ParameterFieldInfo = paramFields;
CrystalReportViewer1.ReportSource =
"c:\\inetpub\\csreports\\crystal\\dailyprod.rpt";
CrystalReportViewer1.DataBind();
Quote:
}