public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptMUONSACH rpt = new rptMUONSACH();
rpt.Site = this.Site;
return(rpt);
}
private void frm_ThongKe_Load(object sender, EventArgs e)
{
rptMUONSACH rpt = new rptMUONSACH();
DataSet ds = new DataSet();
string query = "Select b.MaThe, b.TenBanDoc, s.MaSach, s.TuaDe, s.TacGia, NgayMuon, NgayTra "
+ " from (SACH s inner join MUONSACH m on s.MaSach = m.MaSach) "
+ " inner join BANDOC b on m.MaThe = b.MaThe "
+ " where NgayTra is Null";
SqlDataAdapter da = new SqlDataAdapter(query, XL_BANG.Chuoi_lien_ket);
da.Fill(ds);
rpt.SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = rpt;
}