How i prepare parameterized(with more than one parameters) crystal report.pls tell me the code prodecure,if any body can.

I have written the code for single parameter.not getting the report for morethan one parameter

Interview Candidate
Oct 4th, 2005
3
2126

Showing Answers 1 - 3 of 3 Answers

cipt2001
Profile Answers by cipt2001

Oct 31st, 2005

It works for me with this code:ParameterFields paramFields = new ParameterFields(); //setdata ParameterField param_date = new ParameterField(); param_date.ParameterFieldName = "date"; ParameterDiscreteValue d = new ParameterDiscreteValue(); d.Value = this.date+" - "+this.datesf; param_date.CurrentValues.Add(d); paramFields.Add(param_date); //set number ParameterField param_no = new ParameterField(); param_no.ParameterFieldName = "number"; ParameterDiscreteValue number = new ParameterDiscreteValue(); if (this.no==0) number .Value = ""; else number.Value = this.no.ToString(); param_no.CurrentValues.Add(number); paramFields.Add(param_no); //and so on repview_total.ParameterFieldInfo = paramFields;

Suma_ppn

Nov 4th, 2005

How i prepare parameterized(with more than one par...

Rakesh Kalange

Oct 30th, 2006

FOR .NET 2.0First You have to define parameter fields in the Crystal Report.then on the .Net side you need to write the following codeusing CrystalDecisions.CrystalReports.Engine;using CrystalDecisions.Shared; private void ShowReport() { ReportDocument rptDoc = new ReportDocument(); rptDoc.Load("Report File Path"); //Add Number of parameters for report rptDoc.ParameterFields.Add("Parameter Name Same as defined in the Report", "value as Object", DiscreteOrRangeKind.DiscreteValue, ""); //Parameter name is case & space sensitive crystalReportViewer1.ReportSource = rptDoc; }In case of Web Application there will be few modifications in the code