private void btnSearch_Click(object sender, EventArgs e)
{
string ConnectionString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
using (SqlConnection sqlCon = new SqlConnection(ConnectionString))
try
{
DailyTransactionRpt reportDocument = new DailyTransactionRpt();
ParameterField paramField = new ParameterField();
ParameterFields paramFields = new ParameterFields();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
paramField.Name = "@BcDate";
paramField.Name = "@DueDate";
paramDiscreteValue.Value = dtpfromdate.Text;
paramDiscreteValue.Value = dtpTodate.Text;
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
paramFields.Add(paramField);
crystalReportViewer1.ParameterFieldInfo = paramFields;
//string reportPath = Server.MapPath("~/Memberwisrrptfile.rpt");
reportDocument.Load("~/DailyTransactionRpt.rpt");
//reportDocument.Load(@"D:\New folder\Loanapp11sep\10092015 Loan\Loan-25-07-2015\source\LoanApplication\LoanApplication\Memberwisrrptfile.rpt");
reportDocument.SetParameterValue("@BcDate", dtpfromdate.Text);
reportDocument.SetParameterValue("@DueDate", dtpTodate.Text);
crystalReportViewer1.ReportSource = reportDocument;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
DailyTransactionRpt rpt = new DailyTransactionRpt();
rpt.Site = this.Site;
return rpt;
}
