Regarding parameter fields

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Prabhu Raja15y ago
Accepted 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
0
Hemant Kumar15y ago
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
0