public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReport2 rpt = new CrystalReport2();
rpt.Site = this.Site;
return(rpt);
}
private void frmCrystal_Load(object sender, EventArgs e)
{
cnn = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=QLShopTheThao;Integrated Security=True");
da = new SqlDataAdapter("Select * from db_HoaDon", cnn);
dt_hoadon = new DataTable();
da.Fill(dt_hoadon);
da.SelectCommand.CommandText = " select hd.MaHD,kh.TenKH,sp.TenSP,ctdh.SoLuong,TongTien,ThanhTien "
+ " from db_HoaDon hd join db_ChiTietDonHang ctdh on hd.MaHD = ctdh.MaHD join db_KhachHang kh on hd.MaKH = kh.MaKH, db_SanPham sp"
+ " where hd.MaKH = kh.MaKH and hd.MaHD = ctdh.MaHD and sp.MaSP = ctdh.MaSP";
dt_chitiethoadon = new DataTable();
da.Fill(dt_chitiethoadon);
CrystalReport2 rpt = new CrystalReport2();
rpt.SetDataSource(dt_chitiethoadon.DefaultView);
crystalReportViewer1.ReportSource = rpt;
}