protected void btXuatExcel_Click(object sender, EventArgs e) { if (hiddenEmpID.Value.Trim() != "") { ExcelTop(Convert.ToInt32(hiddenEmpID.Value)); report.DataSource = GetTable(Convert.ToInt32(hiddenEmpID.Value)); ReportViewer1.Report = report; ReportViewer1.WriteXlsTo(Response); } }
protected void btXuatExcel_Click(object sender, EventArgs e) { string unitid = cmbDonVi.SelectedItem.Value.ToString() == "14" ? "0" : cmbDonVi.SelectedItem.Value.ToString(); report.DataAdapter = null; report.DataSource = GetTable(Convert.ToInt32(unitid), dateThongKe.Date); report.ngayThongKe = "Ngày " + dateThongKe.Date.Day + " tháng " + dateThongKe.Date.Month + " năm " + dateThongKe.Date.Year; ReportViewer1.Report = report; ReportViewer1.WriteXlsTo(Response); }