private void btnSearch_Click_1(object sender, EventArgs e) { if (cbGroupName.Text != "SELECT") { if (lblPendingMsg.Text != "") { using (SqlConnection sqlCon = new SqlConnection(ConnectionString)) try { #region //SqlCommand cmd = new SqlCommand("Usp_SearchPendingInstallmentReport", sqlCon); //cmd.Parameters.AddWithValue("@GroupId", Convert.ToInt32(cbGroupName.SelectedValue.ToString())); //cmd.Parameters.AddWithValue("@CustomerId", Convert.ToInt32(CbcustomerName.SelectedValue.ToString())); //cmd.CommandType = CommandType.StoredProcedure; //SqlDataAdapter da = new SqlDataAdapter(cmd); //DataTable dt = new DataTable(); //da.Fill(dt); //try //{ // if (dt.Rows.Count > 0) // { // DataSet1 dset = new DataSet1(); // dataset file name // // DataSet1 dset2 = new DataSet1(); // dset.Tables["Installment"].Merge(dt); // //dset2.Tables["Transactions"].Merge(dt); // Memberwisrrptfile crpt = new Memberwisrrptfile();// .rpt file name // crpt.SetDataSource(dset.Tables["Installment"]); // //crpt.SetDataSource(dset.Tables["Transactions"]); // crystalReportViewer1.ReportSource = crpt; // crystalReportViewer1.Refresh(); // } // else // { // MessageBox.Show("Record does not available"); // } //} //catch (Exception ex) //{ // MessageBox.Show(ex.Message.ToString()); //} #endregion PendingPayment_ReportNew reportDocument = new PendingPayment_ReportNew(); ParameterField paramField = new ParameterField(); ParameterFields paramFields = new ParameterFields(); ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue(); paramField.Name = "@GroupId"; paramDiscreteValue.Value = cbGroupName.SelectedValue.ToString(); paramField.Name = "@CustomerId"; paramDiscreteValue.Value = CbcustomerName.SelectedValue.ToString(); paramField.CurrentValues.Add(paramDiscreteValue); paramFields.Add(paramField); paramFields.Add(paramField); crystalReportViewer1.ParameterFieldInfo = paramFields; //string reportPath = Server.MapPath("~/Memberwisrrptfile.rpt"); //reportDocument.Load("~/PendingPayment.rpt"); reportDocument.Load("~/PendingPayment_ReportNew.rpt"); reportDocument.SetParameterValue("@GroupId", cbGroupName.SelectedValue.ToString()); reportDocument.SetParameterValue("@CustomerId", CbcustomerName.SelectedValue.ToString()); crystalReportViewer1.ReportSource = reportDocument; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { } } else { MessageBox.Show("Please Select Group First"); } } else { MessageBox.Show("Please Select Group First"); } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { PendingPayment_ReportNew rpt = new PendingPayment_ReportNew(); rpt.Site = this.Site; return rpt; }