public DataTable GetTableReport(ReportViewer rpt) { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); try { objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[3]; Parameters[0] = new SqlParameter("@RptType", rpt.SelectedRptType); Parameters[1] = new SqlParameter("@RefKey", rpt.RefKey); Parameters[2] = new SqlParameter("@RptDate", ConvertDatetimeDB(rpt.Date)); var Collector = objDataEngine.FillDt("WebRptViewer", CommandType.StoredProcedure, Parameters); return(Collector); } finally { objDataEngine.CloseConnection(); } }