i have the below code for passing parameters to crystal reprot & displayin g the report
1) even thoug i am passing parameter values i get a screen where its asking for the values
Parameter Field(s)
need to avod this
when the page is loaded no parameter values are passed
2) after enetring the value in the textbox when i click submit i get th e logon error
customerReport = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); ParameterFields paramFields = new ParameterFields(); ParameterField paramField = new ParameterField(); ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue(); paramField.Name = "dept"; paramDiscreteValue.Value = drpdept.SelectedItem.Text; paramField.CurrentValues.Add(paramDiscreteValue); paramField.Name = "emp"; paramDiscreteValue.Value = drpemp.SelectedItem.Text; paramField.CurrentValues.Add(paramDiscreteValue); paramFields.Add(paramField); CrystalReportViewer1.ParameterFieldInfo = paramFields; string reportPath = Server.MapPath("reports/LIST.rpt"); customerReport.Load(reportPath); STR =" Select * from employee where 1=1 "; //if (drpdept.SelectedItem.Text != "--Select--") //{ // STR =STR + "and Department='" + drpdept.SelectedItem.Text + "' "; //} //if (drpemp.SelectedItem.Text != "--Select--") //{ // STR =STR + "and fname+' '+mname+' '+lname ='" + drpemp.SelectedItem.Text + "'"; //} STR =STR + " order by Department "; conn.Open(); SqlDataAdapter adpt = new SqlDataAdapter(STR, conn); DataTable dt = new DataTable(); adpt.Fill(dt); customerReport.SetDataSource(dt); CrystalReportViewer1.ReportSource = customerReport; adpt.Dispose(); dt.Dispose();
