Building Advanced Reports
- Sort by Sum (or count) with Dynamics NAV
- Loading Pictures
- SQL= Reference
- Sort by Sum for data sources other than NAV
- Compare one NAV field against another field
- Using GP SmartList SQL Views to speed up reporting
- Using "Schema=" to return specific data
- Using InclusiveLink=
- Selecting the Specific Key by Function ( Key= )
- Limiting the Number of Records in a Query
- Retrieving Special Fields with NL(Table)
- SQL Views
- Advanced Stored User Data
- Building a Report From Multiple Databases
- Referencing a Blank cell (with @@)
- Conditionally Hiding Rows, Columns or Sheets
- Selecting the Key Search Algorithm
- Using Vendor 1099 Code
- Array Calculations
- Filtering Based on Data from Another Table
- Adding a Date and Time stamp to a Report
- Conditional Replication
- Using NL(Filter)
- Table Cache Optimization
- Using Link=
- Introducing Stored User Data in Reports
- Using SQL=
- Evaluating Formulas