NAV - Jet Reports - How to build a report

• Install Jet
• Launch Excel
• Jet>Data Source Settings>Define Jet Data source
• Connecting to the Cube will enable different tools than connecting to a regular ODBC
• Use these tools to build parts or all of your report
• Row 1 and Column A are restricted and designated for Jet system functions, do not enter values here
• A2 - Keyword Option will display value as an option in report
• B1 - Keyword Title will display value as title in report
• B2 - Keyword Value will display value as an editable field in report
• From B2 onward, you can enter values and labels that can be referenced in formulas
• Formulas (JfX)
• Jet reference
• https://support.jetglobal.com/hc/en-us/articles/218953168-NL-Function-Reference
• Other References
• https://community.dynamics.com/nav/b/technicaltipsandtricksfordynamicsnav/posts/creating-report-in-jet-using-nl-nf-np-amp-gl-amp-excel-formulas
• NF
• NL
• NP
• GL
• Report Wizard
• Select Table
• Select Filter, group, sort options
• Generate simple report off of a single table, similar to a standard pivot table report, but using Jet function syntax
• Direct Query off of Database takes very long
• Generally useless
• Table Builder
• Allows you to build views to join tables and add function logic
• Same as using Excel Query builder
• Slightly less useless
• Pivot Table (Cube Only)
• Will generate pivot table off of cube
• Same functionality as connecting directly to cube from Excel

• Scheduler
• Schedule report to email