Regarding parameter fields

Question

How to work with parameter fields in Crystal Report

Prabhu Raja · Answer

Hi Monica Recently i had worked in Crystal Reports for online Ticket Generation System. So My Code will help you i think. ReportDocument repDoc = new ReportDocument(); repDoc.Load(Server.MapPath(CrystalReport.rpt)); //get Your Crystal Report as ReportDocument. Provide your Cystal Report name in Double Quotes TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); // ConnectionInfo crConnectionInfo = new ConnectionInfo(); // You may use this for  if you want sent Connection String information to Report crConnectionInfo.ServerName = WebConfigurationManager.AppSettings[ServerName]; // Connection String Information crConnectionInfo.DatabaseName = WebConfigurationManager.AppSettings[DatabaseName]; crConnectionInfo.UserID = WebConfigurationManager.AppSettings[UserID]; crConnectionInfo.Password = WebConfigurationManager.AppSettings[Password]; crtableLogoninfo = repDoc.Database.Tables[0].LogOnInfo; //Set Connection String Information to Report crtableLogoninfo.ConnectionInfo = crConnectionInfo; repDoc.Database.Tables[0].ApplyLogOnInfo(crtableLogoninfo); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); // Parameter Section your need ParameterField ticketTransactionId = repDoc.ParameterFields[0]; // Parameter 1 you can send more then one paramter to report ParameterDiscreteValue tickettranvalue = new ParameterDiscreteValue(); tickettranvalue.Value =  Parameter 1 // Set Value for Parameter Here ticketTransactionId.CurrentValues.Add(tickettranvalue); ParameterField baseURLParameter = repDoc.ParameterFields[1]; // parameter 2 Just Index is Changed ParameterDiscreteValue baseURLParameterValue = new ParameterDiscreteValue(); baseURLParameterValue.Value =  parameter 2 ; // Set Value for Parameter Here baseURLParameter.CurrentValues.Add(baseURLParameterValue); // this is my requirment repDoc.ExportToHttpResponse(ExportFormatType.PortableDocFormat Response true Report); // Export Report as PDF Document repDoc.Export(); ----------------------------------------------------------------------------------------- If this post helps you then mark as Correct Answer Thank You

Hemant Kumar · Answer

Hi Please refer this link http://www.c-sharpcorner.com/UploadFile/john_charles/WorkingwithParameterFieldsinCrystalReports06232008102249AM/WorkingwithParameterFieldsinCrystalReports.aspx http://www.dotnetheaven.com/UploadFile/SaifiFFC/CrystalReport07122007062723AM/CrystalReport.aspx