User Guide

• Navigating the Application
• Keyboard Shortcuts
• Report Types
• Building Your First Report
• What are formulas?
• Formula Editor
• Aggregate Functions
• Financial Functions
• Date Functions
• Arithmetic and Geometric Functions
• Formatting Functions
• String Functions
• JSONExtract Function
• Logical Functions
• Database and Data Type Functions
• Other Functions
• ExpressView: Introduction (v2021.1+)
• ExpressView: Grouping (v2021.1+)
• ExpressView: Aggregating/Summarizing Data (v2021.1+)
• ExpressView: Sorting (v2021.1+)
• ExpressView: Filtering (v2021.1)
• ExpressView: Formula Columns (v2021.1+)
• ExpressView: Visualizations (v2021.1+)
• ExpressView: Exporting (v2021.1+)
• Report Viewer
• Report Designer (v2021.1+)
• Advanced Reports: Data Objects (v2021.1+)
• Advanced Reports: Sections (v2021.1+)
• Advanced Reports: Design Grid (v2021.1+)
• Advanced Reports: Sorts
• Filters
• Group Min/Max Filters
• Top/Bottom Filters
• Sorting by Aggregates
• Advanced Reports: Report Options
• Advanced Options
• Internal Parameters
• Advanced Reports: Templates
• Advanced Reports: Joins
• Advanced Joins
• Advanced Reports: CrossTabs
• Cell Formatting
• Conditional Row Suppression
• Linked Reports (Drilldowns)
• Display Page Numbers
• Dashboard Viewer (v2019.2+)
• Dashboard Designer (v2019.2+)
• Dashboard Designer: Existing Report Tiles (v2019.2+)
• Dashboard Designer: Visualization Tiles (v2019.2+)
• Dashboard Designer: Image Tiles (v2019.2+)
• Dashboard Designer: Text Tiles (v2019.2+)
• Dashboard Designer: URL Tiles (v2019.2+)
• Dashboard Designer: Filters (v2019.2+)
• Dashboard Designer: Parameters (v2019.2+)
• Exporting Dashboards (v2019.2+)
• Charts and the Chart Wizard
• Chart Data Layout Types
• Bar Charts
• Line Charts
• Pie, Doughnut, Pyramid, and Funnel Charts
• Spark Charts
• Pareto Charts
• Scatter and Bubble Charts
• Heatmap Charts
• GeoCharts
• Google Maps
• Gauges
• Tabular Visualizations
• Displaying Null Values in Charts
• Chained Reports
• Scheduling Reports
• User Preferences and Context Sensitive Help