Jet from insightsoftware

Multi-level Grouping and Subtotaling Tutorial
Multi-level Grouping and Subtotaling Tutorial This tutorial builds on the Grouping Tutorial so if you haven't yet completed it, please do so before starting this tutorial. Multi-Level Grouping (Dynamics NAV Example) Often we want a report to contain more than one level of grouping.  For instance, we might want to add more detail to the earlier example by not only ...
Sorting Your Jet Reports
Sorting Your Jet Reports Beginner Related Articles... Overview By default, results returned by a Jet function are sorted in ascending order based on the field values returned. However, it is an easy task to override the default and sort in ascending descending order based on any field in the table you are using. Terminology First, it's important to understand the ...
Report Options in Jet Basics
Report Options in Jet BasicsJet Basics Help Topics... Overview To display the Report Options window when running a report, you use the following worksheet tags: Option , Title , Value , and Tooltip . Each row of the worksheet containing an option you want to appear in the Report Options window must contain the Option tag in Column A. The column contain...
Sorting NL("Last") and NL("First") functions
Sorting NL("Last") and NL("First") functions NL(Last) and NL(First) are dependent upon sort order When using the NL() function with the WHAT parameter of "Last", this is going to pull back the last matching record in the table.  However, the last record in the table is subject to change based on how Dynamics NAV is sorting the records overall.  So the last record in the table is not alw...
Using NL( Lookup )
Using NL( Lookup ) Beginner Related Articles... Overview Adding Report Options to your report allows others to select specific filters to narrow down the information they want to view. The NL("Lookup") function can be used to allow users of the report (either Designers or Viewers) to see and select from a list of available values when setting their Report Options. Exa...
First Page
Back
For an optimal Community experience, Please view on Desktop