public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReport_0 rpt = new CrystalReport_0();
rpt.Site = this.Site;
return(rpt);
}
private void fReport_Load(object sender, EventArgs e)
{
String sql = "";
if(status == null)
{
sql = "select * from dbo.viewRepostBill where bill_id = " + bill;
CrystalReport1 crystalReport = new CrystalReport1();
crystalReport.SetDataSource(conn.getTable(sql));
crystalReportViewer1.ReportSource = crystalReport;
}
else
{
if(status == "0")
{
sql = "select* from viewtblBill where sTrangthai = 1";
}else if( status == "1")
{
sql = "select * from viewtblBill where dThoigianthanhtoan between '" + date1 + "' and '" + date2 + "'";
}else if(status == "2")
{
sql = "select* from viewtblBill where sTrangthai = 1 and DAY(GETDATE()) = DAY(dThoigianthanhtoan) and MONTH(GETDATE()) = MONTH(dThoigianthanhtoan)" +
"and YEAR(GETDATE()) = YEAR(dThoigianthanhtoan)";
}
CrystalReport_0 crystalReport_0 = new CrystalReport_0();
crystalReport_0.SetDataSource(conn.getTable(sql));
crystalReportViewer1.ReportSource = crystalReport_0;
}
}
