Pass value of text box to crystal report using parameter

Hello Everyone,

I am Try to pass text box values to crystal report in asp.net.

but it will not fount parameter in my code. it will show popup parameter dialog box window to get value for crystal report.

Below is my Source code for parameter Passing :

ReportDocument reportDocument = new ReportDocument();

ParameterFields paramFields = new ParameterFields();

ParameterField paramField = new ParameterField();

ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();

paramField.Name = "@Name";

paramDiscreteValue.Value = TextBox1.Text.ToString();

paramField.CurrentValues.Add(paramDiscreteValue);

paramFields.Add(paramField);

CrystalReportViewer1.ParameterFieldInfo = paramFields;

reportDocument.Load(Server.MapPath("CrystalReport1.rpt"));

if (conn.State == ConnectionState.Open)

{

conn.Close();

}

conn.Open();

string sql = "select * from CustomerDetails";

OdbcCommand cmd = new OdbcCommand(sql, conn);

OdbcDataAdapter dscmd = new OdbcDataAdapter(cmd);

DataTable datatable = new DataTable();

dscmd.Fill(datatable);

conn.Close();

reportDocument.SetDataSource(datatable);

CrystalReportViewer1.ReportSource = reportDocument;

If anybody Knows please help me..

Thanks In Advance.

4 Replies

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

Gowtham Rajamanickam11y ago
http://stackoverflow.com/questions/15153402/how-to-pass-value-in-textfield-in-crystalreport-from-textbox-in-vb-net
Gowtham Rajamanickam11y ago
http://www.c-sharpcorner.com/Blogs/12675/to-pass-textbox-value-to-crystal-report-without-using-databa.aspx
Gowtham Rajamanickam11y ago
http://www.codeproject.com/Questions/992954/how-to-Pass-value-of-text-box-to-crystal-report-us
Gowtham Rajamanickam11y ago
http://www.c-sharpcorner.com/UploadFile/jayendra/109272009060421AM/1.aspx