MICROSOFT DYNAMICS™ NAV TRAINING

NAV25 - Advanced Reporting with Jet Reports (1 Day)

Course Aims

To enable the delegate to have a good understanding of the specialist Jet Reports functionality and its ability to create Microsoft Dynamics™ NAV reports, charts and graphs directly within Excel.

Who should attend?

All 'User Champions'

Pre-Requisites

Delegates should have a good working knowledge of both Microsoft Dynamics™ NAV and Excel.

Course NAV01 - System Overview & Architecture or similar knowledge level

Course Content

Introduction to Jet Reports

• Static Reports


• Dynamic Reports

Creating Static Reports

• Using the GL command


• Using Excel cell addressing modes


• Construct date filters using Excel date formulas


• Using the NL command for data retrieval

Building Dynamic Format Reports

• Building Simple lists


• Replicators


• Unique values


• Using the NL and NF commands together


• Sorting with the NL command


• Working with Excel's formula ranges


• Conditionally hiding data

Intermediate Dynamic Reports

• Nested Replicators


• Grouping lists by multiple criteria

Jet Reports installation & maintenance

C/FRONT & Microsoft Dynamics™ NAV

Jet Reports is a third-party add-on tool for Microsoft Dynamics™ NAV and can be supplied by Cambridge Online

• No dates currently available

Fees

• 1 Day Course: £250

Notes

• This course is based on Microsoft Dynamics™ NAV functionality



• This course is provided on the GB version of Microsoft Dynamics™ NAV



• This course can be delivered exclusively for your company at your premises. Please contact us for more details