I want to set textbox1 value into formula field of crystal reports and Utilise the same value into crystal reports.
Suppose my Textbox1 value is "12000" and I want to set it to formula field and utilize the same into crystal reports. Is it possible?. And yes then How?.
Note: textbox1 located on top of CrystalReportviewer1.
shital kothariPosted Jun 11, 2012, 7:08 PM
CrystalReportViewer1.refresh();
CrystalReportViewer1.Show();
or
You can pass the parameters to crystal reports,
as follows:
ReportDocument rpt = new ReportDocument();
rpt.Load(Server.MapPath((string)Session["RPT_NAME"]));
int cnt = rpt.DataDefinition.ParameterFields.Count;
for (int i = 0; i < cnt; i++)
{
ParameterValues myvals = new ParameterValues();
ParameterDiscreteValue myDiscrete = new ParameterDiscreteValue();
switch (rpt.DataDefinition.ParameterFields[i].ParameterValueKind)
{
case CrystalDecisions.Shared.ParameterValueKind.DateTim eParameter:
myDiscrete.Value = Convert.ToDateTime(Request.QueryString[i]);
break;
case CrystalDecisions.Shared.ParameterValueKind.Boolean Parameter:
myDiscrete.Value = bool.Parse(Request.QueryString[i]);
break;
case CrystalDecisions.Shared.ParameterValueKind.DatePar ameter:
myDiscrete.Value = Convert.ToDateTime(Request.QueryString[i]);
break;
case CrystalDecisions.Shared.ParameterValueKind.NumberP arameter:
myDiscrete.Value = int.Parse(Request.QueryString[i]);
break;
case CrystalDecisions.Shared.ParameterValueKind.StringP arameter:
myDiscrete.Value = Convert.ToString((Request.QueryString[i]));
break;
}
myvals.Add(myDiscrete);
rpt.DataDefinition.ParameterFields[i].ApplyCurrentValues(myvals);
}
CrystalReportViewer1.ReportSource = rpt;
CrystalReportViewer1.DataBind();
You can use the parameter fields in formulaes,
Thanking You,