problem crystal report and aspx

vaquas khan

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 also suggest how to convert the dropdownlist value or datepicker selectedDate for sesson variable..

this below code is suggested by one member of this site but it is not work......

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;
}

2 Replies

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

Rekha Singh16y ago
Accepted answer
this example is only for one parameter

step 1: go to to Global.asax(add this by right clicking ur solution explorer and select add new item) . in this create a session called session["OrderNo"] in ur session_start event .

void Session_Start(object sender, EventArgs e)
{Session["OrderNo"] = "";}

step 2 :
go to ur first page add this code in ur button click event
protected void Button1_Click(object sender, EventArgs e)
{
DropDownList1.SelectedValue= Session["OrderNo"].ToString();
Response.Redirect("Default2.aspx");
//Default2.aspx is the second page whr u have ur crystal report
}

step 3 :

add this code in ur page_load event of second page
protected void Page_Load(object sender, EventArgs e)
{
ReportDocument rpt = new ReportDocument();
rpt.Load(Server.MapPath("CrystalReport.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;
}

this code is working fine for me.. try out once more n let me know..

0
Rekha Singh16y ago
hey tell me one thing.. how are u binding ur crystal report.. is it with a stored procedure from database which askes for these 2 parameter???
0

problem crystal report and aspx

hey tell me one thing.. how are u binding ur crystal report.. is it with a stored procedure from database which askes for these 2 parameter???