Jet Reports is a Microsoft Excel Add-in that integrates Excel with Microsoft Dynamics NAV, GP, or any database that has an OLE or ODBC driver available. With this add-in, you can create reports with simple worksheet functions.
Instead of printing a report and re-entering data into worksheets, you can enter formulas that read directly from your database and refresh the data right in Excel.
To use Jet, you should have experience with Microsoft Excel, including cell referencing and worksheet functions. You should also have a basic understanding of your database structure.
Jet Function References:
The Jet add-in adds four functions to Excel: NL, NF, NP, and GL.
|NL Function||GL Function||NF Function||NP Function|
The NL function directly queries and returns values from any field in any table in your database. You can set as many as ten filters to define which record(s) you want.
The NF Function is a shortcut. You can define which record you want with the NL function, and then you can retrieve multiple fields from that record with the NF function. By using the NF function, you do not have to retype all the filters for each field you want to retrieve.
The NP function is a utility function which allows you to do certain tasks to speed up your reports or make them more convenient. You can use NP to create date filters, evaluate formulas or do array operations, among other things.
The GL function combines multiple NL functions to make General Ledger reporting even easier for Dynamics NAV and Dynamics GP users. The GL function is not available with other data source types.