Skip to main content

Home Videos Support Sign in

Jet
Product Documentation
Report Design
Report Writing Techniques

Report Writing Techniques

Excel Date Functions
Use Jet Reports Dashboard Mode
Group and Subtotal Data
Filter Based on Data from Another Table
Build a Report From Multiple Data Sources
Indicate a Blank Cell
Hide Rows, Columns or Sheets Conditionally
Sort by Sum with Dynamics NAV and Business Central
Sort by Sum for data sources other than NAV
Use the Excel IF function with Jet Reports
Limit the Number of Records in a Query
Use SQL Views
Use NL Filter
Use Link
Use Inclusive Link
Using SQL=
Select the Key Search Algorithm
Select the Specific Key by Function
Use Schema to return specific data
SQL= Reference
Use a Detail List or a Summary List
Compare one NAV field against another field
Use GP SmartList SQL Views to speed up reporting
Retrieve Special Fields with NL(Table)
Array Calculations
Add a Date and Time stamp to a Report
Table Cache Optimization
Evaluate Formulas
Load Pictures
Use Stored User Data in Reports

Next
Last