public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
RpNam rpt = new RpNam();
rpt.Site = this.Site;
return(rpt);
}
private void btnxuatnam_Click(object sender, EventArgs e)
{
string Nam = txtnam.Value.Date.ToString("yyyy");
string sql = "SELECT COUNT(SOHD) AS SOHD,FORMAT(NGHD,'MM/yyyy') AS NGHD,SUM(TONGGIA) AS TONGGIA FROM HOADON WHERE NGHD IS NOT NULL "
+ " AND YEAR(NGHD) = '" + Nam + "' GROUP BY FORMAT(NGHD,'MM/yyyy')";
DataTable dt = new DataTable();
RpNam BC = new RpNam();
dt = sp_BUS.Display(sql);
BC.SetDataSource(dt);
crystalReportViewer1.ReportSource = BC;
crystalReportViewer1.Refresh();
}
