missing parameter values during run-time in crystal report

Nithya Dhamodaran

Hi to all,

In ASP.NET C# language, displaying crystal report on button click and passing from date and to date (in textbox) as parameters in crystal report, finally the report processing successfully. But only the hindrance was after processing the report, when am trying to zoom, error occurs - MISSING PARAMETER VALUES (during run-time), also when clicking export, print option in toolbar.

Herewith, I have attached my program file. kindly let me know the solution as soon as possible.

Thanks in advance.....
Nithya Dhamodaran.

7 Replies

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

Nitesh Kejriwal12y ago
Please note that you will need to set the parameters in the export button click and zoom as well. The link I shared shows how to do this in win forms. You can adapt it for web forms.
Nithya Dhamodaran12y ago
sir,i have already said that am using web form... i think this is not right code for me...actually i wanna know where am missing the parameter... whether its taking default parameter for this report? and where should is use it?
Nitesh Kejriwal12y ago
Check this link -
http://scn.sap.com/thread/3245783
Nithya Dhamodaran12y ago
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

namespace testfd
{
public partial class _Default : System.Web.UI.Page
{
private void Page_Init(object sender, EventArgs e)
{
TextBox1.Text = DateTime.Now.ToShortDateString();
TextBox2.Text = DateTime.Now.ToShortDateString();
}

protected void Page_Load(object sender, EventArgs e)
{

}

protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
if (Cal1.Visible == false)
{
Cal1.Visible = true;
}
else
{
Cal1.Visible = false;
}
}

protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
{
if (Cal2.Visible == false)
{
Cal2.Visible = true;
}
else
{
Cal2.Visible = false;
}
}

protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
TextBox1.Text = Cal1.SelectedDate.ToShortDateString();
Cal1.Visible = false;
}

protected void Calendar2_SelectionChanged(object sender, EventArgs e)
{
TextBox2.Text = Cal2.SelectedDate.ToShortDateString();
Cal2.Visible = false;
}

protected void btnPreview_Click(object sender, EventArgs e)
{
ReportDocument report = new ReportDocument();
report.Load(Server.MapPath("CrystalReport1.rpt"));
report.SetDatabaseLogon("VRPLNEW", "VRPLNEW", "ERP", "");
report.SetParameterValue("FROMDATE", TextBox1.Text);
report.SetParameterValue("TODATE", TextBox2.Text);
CrystalReportViewer1.ReportSource = report;
}

protected void btnBack_Click(object sender, EventArgs e)
{
Response.Redirect("Default.aspx");
}
}
}
Nitesh Kejriwal12y ago
Please share some code that you're using.
Nithya Dhamodaran12y ago
am using asp.net... pls provide me other option without dataset...
Nitesh Kejriwal12y ago
Check this link ....
http://www.c-sharpcorner.com/UploadFile/mahesh/paramInCR11012006132839PM/paramInCR.aspx