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(); }