Chained Reports
Chained Reports combine multiple reports into a single multi-page document. They are a convenient way to bundle related reports into a format suitable for printing or sending to a mailing list.
Reporting
Bar Charts
Bar
Bar charts use rectangular bars that extend horizontally to show comparisons between categories. Each data value is represented by a bar, the length of which represents its quantity. Bar charts can be single-series (one bar per category) or multi-series (multiple bars per category, each ...
Chart Data Layout Types
There are several ways to represent this collection of points on a report, and the application must be able to transform them into a chart regardless of the design you've chosen. For this reason, the Chart Wizard comes with three Data Layout Types. Understanding the way you've designed your report and data will help you select the right Layout Type, which will in turn tell the application how to transform your data into a chart.
Charts and the Chart Wizard
Charts are a way of illustrating data in order to make it easy to spot trends and patterns. Most types of charts are simply a collection of points on a grid, with interstitial designs and labels that make them easier to read.
By default, charts are generated dynamically, based on data ...
Aggregate Functions
Aggregate Functions calculate values based on two factors: the input cell, which is usually but not always a data field, and the report section that the function is located, relative to the input. The location of the function determines which, and how many cell values will be sent to the ...
Arithmetic and Geometric Functions
Basic mathematical functions, as well as number field manipulation like truncation and rounding.
Abs
Description
Returns the absolute value of a number.
Remark
Example
Abs(-23.1) – returns 23.1.
Acos
Description
Returns the arccosine, or inverse cosine, of a ...
Chart Advanced Features: Area
The following sections provide a list of available advanced attributes available for controlling and customizing Area chart elements.
Note
This article contains documentation for advanced attributes which are third-party customizations that must be manually entered into the chart wizard. ...
Chart Advanced Features: Bar 2D
The following sections provide a list of available advanced attributes available for controlling and customizing 2D Bar chart elements.
Note
This article contains documentation for advanced attributes which are third-party customizations that must be manually entered into the chart wizard. ...
Chart Advanced Features: Bar 3D
The following sections provide a list of available advanced attributes available for controlling and customizing 3D Bar chart elements.
Note
This article contains documentation for advanced attributes which are third-party customizations that must be manually entered into the chart wizard. ...
Chart Advanced Features: Bubble
The following sections provide a list of available advanced attributes available for controlling and customizing Bubble chart elements.
Note
This article contains documentation for advanced attributes which are third-party customizations that must be manually entered into the chart wizard. ...
Chart Advanced Features: Column 2D
The following sections provide a list of available advanced attributes available for controlling and customizing 2D Column chart elements.
Note
This article contains documentation for advanced attributes which are third-party customizations that must be manually entered into the chart ...
Chart Advanced Features: Column 3D
The following sections provide a list of available advanced attributes available for controlling and customizing 3D Column chart elements.
Note
This article contains documentation for advanced attributes which are third-party customizations that must be manually entered into the chart ...
Chart Advanced Features: Combination 2D
The following sections provide a list of available advanced attributes available for controlling and customizing 2D Combination chart elements.
Note
This article contains documentation for advanced attributes which are third-party customizations that must be manually entered into the chart ...
Chart Advanced Features: Combination 3D
The following sections provide a list of available advanced attributes available for controlling and customizing 3D Combination chart elements.
Note
This article contains documentation for advanced attributes which are third-party customizations that must be manually entered into the chart ...
Advanced Options
The Report Designer's Advanced Options enable features such as report-level join configuration, Server Events, report-level parameters and the Show SQL dialog.
Cell Formatting
Use the Report Designer's Format Cells dialog to customize how data values will display, add custom cell borders, and apply formatting based on certain conditions.
Advanced Reports: Categories (pre-2021.1)
Use the Categories window to select which data to use on the report. This articles applies to versions of the application released before v2021.1.
Custom Aggregate Function: AggConcat()
Returns a concatenated string of values separated by a specified delimiter string.
Custom Aggregate Function: AggCountIf()
Returns the count of values of dataToAggregate with a corresponding true condition. Only those records with a true condition are included in the count.
Custom Aggregate Function: AggDistinctAvg()
Returns the average of only unique values in a series of values.
