crystal repor and aspx problem

i made a crystal report and using two parameter OrderNo,and CustName i want to display parameters on my aspx1 page ,aspx1 page

have two dropdown one for orderno and other for CustName and one button when user select the these two value from dropdown

and click the button then its value pass to aspx2crystal report page for filtering .....please give me an example

please help me

in button_click event of page1.aspx just add values from ur dropdown to ur session variable

protected void Button1_Click(object sender, EventArgs e)
{
DropDownList1.SelectedValue = Session["OrderNo"].ToString();
}

now in ur page2.aspx add a CrystalReportViewer and in page load add this code
protected void Page_Load(object sender, EventArgs e)
{
ReportDocument rpt = new ReportDocument();
rpt.Load(Server.MapPath("Report.rpt"));
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = Session["OrderNo"];
crParameterFieldDefinitions = rpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@OrderNo"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
CrystalReportViewer1.Visible = true;
CrystalReportViewer1.ReportSource = rpt;
CrystalReportViewer1.DisplayGroupTree = false;
}
hope its helpful
*****************************************
Please mark it Accepted if u find it helpful.

1 Reply

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

Rekha Singh16y ago
Accepted answer
in button_click event of page1.aspx just add values from ur dropdown to ur session variable

protected void Button1_Click(object sender, EventArgs e)
{
DropDownList1.SelectedValue = Session["OrderNo"].ToString();
}

now in ur page2.aspx add a CrystalReportViewer and in page load add this code
protected void Page_Load(object sender, EventArgs e)
{
ReportDocument rpt = new ReportDocument();
rpt.Load(Server.MapPath("Report.rpt"));
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = Session["OrderNo"];
crParameterFieldDefinitions = rpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@OrderNo"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
CrystalReportViewer1.Visible = true;
CrystalReportViewer1.ReportSource = rpt;
CrystalReportViewer1.DisplayGroupTree = false;
}
hope its helpful
*****************************************
Please mark it Accepted if u find it helpful.
0