public void DisplayReportSalesAuto(string fileName, string fileName2, DataTable dt, DataTable dt2, DateTime d1, DateTime d2) { string periode = String.Format("{0} s/d {1}", ((DateTime)d1).ToString("dd/MM/yyyy"), ((DateTime)d2).ToString("dd/MM/yyyy")); List <ReportParameter> rptParams = new List <ReportParameter>(); rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID)); rptParams.Add(new ReportParameter("periode", periode)); rptParams.Add(new ReportParameter("Cabang", GlobalVar.Gudang)); frmReportViewer ifrmReport; ifrmReport = new frmReportViewer("Laporan.Salesman.rptPerbandinganSODONotaBO.rdlc", rptParams, dt, "dsOrderPenjualan_SODONotaBO"); ifrmReport.ExportToExcelAuto(fileName); frmReportViewer ifrmReport2 = new frmReportViewer("Laporan.Salesman.rptLapSalesmanDOBONotaDetail.rdlc", rptParams, dt2, "dsOrderPenjualan_DOBONotaDetail"); ifrmReport2.ExportToExcelAuto(fileName2); }
public void DisplayReportGITAuto(string fileName, DataTable dt, DateTime d1, DateTime d2) { string periode; periode = String.Format("{0} s/d {1}", ((DateTime)d1).ToString("dd/MM/yyyy"), ((DateTime)d2).ToString("dd/MM/yyyy")); string reportType = string.Empty; reportType = "Penjualan.rptLaporanGoodInTransitAuditVersion.rdlc"; //construct parameter List <ReportParameter> rptParams = new List <ReportParameter>(); rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID)); rptParams.Add(new ReportParameter("Periode", periode)); //call report viewer frmReportViewer ifrmReport = new frmReportViewer(reportType, rptParams, dt, "dsToko_Data2"); ifrmReport.ExportToExcelAuto(fileName); }