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

Regarding parameter fields

Answers (2)