public void Read()
{
this.reportQuary = fromdateTimePicker.Text + " to " + todateTimePicker2.Text;
string query = "";
query = "Select * From TbAccountStatement Where CreateDate BETWEEN '" + fromdateTimePicker.Value.Date + "' AND '" + todateTimePicker2.Value.Date + "' Order By AutoId";
if (query != "")
{
SqlConnection conn = new SqlConnection(this.connectionString);
SqlCommand comm = new SqlCommand(query, conn);
SqlDataAdapter adap = new SqlDataAdapter();
AccountStatementDataSet dataset = new AccountStatementDataSet();
AccountStatementCrystalReport crp = new AccountStatementCrystalReport();
try
{
conn.Open();
adap.SelectCommand = comm;
adap.Fill(dataset, "DataTable1");
crp.SetDataSource(dataset);
ParameterValues v = new ParameterValues();
ParameterDiscreteValue dv = new ParameterDiscreteValue();
dv = new ParameterDiscreteValue();
dv.Value = this.reportQuary;
v.Add(dv);
crp.DataDefinition.ParameterFields["report_query"].ApplyCurrentValues(v);
crystalReportViewer1.ReportSource = crp;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
conn.Close();
}
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
AccountStatementCrystalReport rpt = new AccountStatementCrystalReport();
rpt.Site = this.Site;
return rpt;
}