Report Design
Fundamentals
- Jet Reports User Interface
- Jet Reports - Best Practices
- The Jet Function Wizard (Jfx)
- What is a Designer? A Viewer? An Excel User?
- Difference between "Design Mode" and "Report Mode"
- Jet Basics - Filter Syntax
Report Building Tools
- Your First Reports - a user guide
- Table Builder and NL("Table")
- Editing a Table with Table Builder
- The Report Wizard
- Create a Word-based report with Export to Word
- Create a Pivot Table from Jet Reports
Building Financial Statements
- GL Function for Dynamics NAV and Business Central
- GL Function for Dynamics GP
- Best Practices - G/L Reports
- Converting from Management Reporter or FRx to Jet Reports or Jet Basics
- Tutorial Videos for using Jet Reports Financials
- Modifying a template with Jet Reports Financials
Creating and Editing Jet Functions (Jfx)
Filtering Data
- Special Characters in a Filter
- Filter Ranges and Excel
- Blank Filters - using @@ and other techniques
- Filter Syntax In Your Jet Reports
- Creating a Filter to include XX* but exclude *YY
- Using more than 10 filters in an NL() function
Report Writing Techniques
- Useful Excel Date Functions
- Grouping and Subtotaling Tutorial
- Filtering Based on Data from Another Table
- Building a Report From Multiple Data Sources
- Referencing a Blank cell (with @@)
- Conditionally Hiding Rows, Columns or Sheets
Building Dashboards
- Sample Dashboards
- Combo Chart and Secondary Axis
- Snap-to-Grid Configuration in the Dashboard Builder
- Dashboard Export/Import
- Jet Reports Dashboard Mode
- Bubble & Scatter Charts