How to pass parameters through textbox, dropdownlist to crystal reports? |
|
Answered By
Moderator1
on
2/20/2010 4:52:23 AM |
|
|
|
|
Hi,
1. To know how to insert, update, delete records in gridview read our article at, http://www.aspdotnetcodes.com/GridView_Insert_Edit_Update_Delete.aspx
2. To Pass parameters through code-behind to Crystal Report, follow the below syntax,
ReportDocument myreport = new ReportDocument();
myreport.Load(Server.MapPath("CrystalReport.rpt"));
ParameterFields pFields = new ParameterFields();
ParameterField pField = new ParameterField();
ParameterDiscreteValue disvalue = new ParameterDiscreteValue();
disvalue.Value = "Your Value to Pass to Parameter"
pField.Name = "@param1";
pField.CurrentValues.Add(disvalue);
pFields.Add(pField);
CrystalReportViewer1.ParameterFieldInfo = pFields;
myreport.SetDataSource(dt);
CrystalReportViewer1.ReportSource = myreport;
CrystalReportViewer1.DataBind();
Note: @param1 must be created in crystal report and placed in proper place in crystal report. |
|
|
|