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