How To Set textbox1 Value Into Formula Filed Of Crystal Reports

Question

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 kothari · Answer

CrystalReportViewer1.SelectionFormula = "{tableName.FiledName=" +Textbox1.text +"}" 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 { 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,