public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptThongKe rpt = new rptThongKe();
rpt.Site = this.Site;
return(rpt);
}
private void frmTK_Load(object sender, EventArgs e)
{
var query = "SELECT HOADON.MaHD, SUM(CTHD.Soluong) AS SL, HOADON.NgayLap, SUM(CTHD.Soluong * SACH.DonGia) AS ThanhTien " +
"FROM CTHD INNER JOIN HOADON ON CTHD.MaHD = HOADON.MaHD INNER JOIN" +
" SACH ON CTHD.MaSach = SACH.MaSach" +
" where MONTH(HOADON.NgayLap)= " + Thang + "AND YEAR(HOADON.NgayLap)= " + Nam +
" GROUP BY HOADON.MaHD, HOADON.NgayLap ";
SqlDataAdapter da = new SqlDataAdapter(query, XLBANG._cnn);
try
{
DataTable tblData = new DataTable();
da.Fill(tblData);
rptThongKe rpt = new rptThongKe();
rpt.SetDataSource(tblData);
crvTK.ReportSource = rpt;
}
catch (SqlException ex)
{
MessageBox.Show(ex.ToString());
}
}
