The Design Grid is main interaction point of the Advanced Report Designer. Use the Design Grid to define the layout of the report by adding, altering and deleting rows, columns, and sections to it; and to define the content of the report by entering data fields, text, labels, formulas, images, charts, CrossTabs and maps to it.

Use the Design Grid to build the layout of the report. This article applies to versions of the application released before v2021.1.

A data object is a container for reportable information from a source of data. When creating a new Advanced Report, data objects will be added to the report with the Add Data Objects dialog, which will appears when launched for the first time.

Custom Options allow for the definition of settings that users can modify on a per-report basis in the Report Designer. Options can be accessed during report execution by Server Events or Custom Functions.

Use a CrossTab, or cross tabulation, for grouping and summarizing data fields that expands vertically and horizontally depending on the number of data groupings. CrossTabs are also known as two-way tables, contingency tables, or pivot tables.

Joins describe how the Data Objects on a report are related to each other. When two objects are joined, a field in the first object is associated with a field in the second object. Wherever a value in the first object's field matches a value in the second object's field, that value's rows from each object come together to form a composite row. The table produced by all the composite rows is the resulting data that appears on the report.

In this video, we’ll be walking through creating a new Advanced Report with the New Report Wizard.