1 Day

Overview
Following on from the Basic Excelerator reporting course, this advanced course will further enhance your Excelerator reporting skills, with advanced functionality including the use of the Unit4 ERP report engine.

Course Agenda

• Excelerator and ERP
• ERP Browser output to Excelerator
• ERP menu output to Excelerator
• Install UNIT4 Excelerator Add-in
• Introduction to Report Engine 9.X
  • Report Engine SQL (ReSql) and the Data Extraction process
  • The Report Engine application
  • Get data
  • The resulting data
  • Using Query [Dataset] select
  • Create a new Excelerator report
  • agr_getbrowser
  • agr_getbalance
  • Data from any table or view in the database
  • QUERY SELECT example
• ERP Browser output to Excelerator via rerx
• ERP Server report and Excelerator (using rerx)
• How to select an SQL parser

 Cost per Attendee = €400 / £350

Please read our cancellation policy and booking terms and conditions.