private void frmDoanhThu_Load(object sender, EventArgs e) { DoanhthuReport dt = new DoanhthuReport(); string select = ""; if (thang != "" && nam != "") { select = "SELECT * FROM v_doanhthu WHERE Tháng='" + thang + "' AND Năm='" + nam + "'"; dt.SetDataSource(DataConn.GrdSource(select).Tables[0]); crystalReportViewer1.ReportSource = dt; } else if (thang != "" && nam == "") { //MessageBox.Show("Thang!= va nam== "); select = "SELECT * FROM v_doanhthu WHERE Tháng='" + thang + "'"; dt.SetDataSource(DataConn.GrdSource(select).Tables[0]); crystalReportViewer1.ReportSource = dt; } else if (thang == "" && nam != "") { select = "SELECT * FROM v_doanhthu WHERE Năm='" + nam + "'"; dt.SetDataSource(DataConn.GrdSource(select).Tables[0]); crystalReportViewer1.ReportSource = dt; } else { select = "SELECT * FROM v_doanhthu"; dt.SetDataSource(DataConn.GrdSource(select).Tables[0]); crystalReportViewer1.ReportSource = dt; } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { DoanhthuReport rpt = new DoanhthuReport(); rpt.Site = this.Site; return(rpt); }