Grouping a column of data breaks up the rows into sections which share a common trait. Each iteration of a group is a unique row in a data column. Grouping data allows you to easily identify rows with common factors. This article applies to versions of the application released prior to v2021.1.

ExpressView is a report building tool that combines grouping, sorting, filtering, and summarizing data with a drag-and-drop interface. A chart can be added with a single click, and the entire report can be exported as PDF, RTF, CSV, or an Excel workbook.

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.

Additional database connection types are available using ADO.NET drivers provided by CData Software Inc., in partnership with Exago Inc., to connect to database types not natively included in the application.

Joins are the relationship data objects have to each other. Join information is accessible and editable via REST.

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.

Data Objects are the tables, views, methods, stored procedures, functions and custom SQL made accessible from the Data Sources for reports. This article applies to the Admin Console > Data > Objects settings.

Endpoints for the manipulation of Data Objects (also known as "Entities") in the REST API.

Data Sources establish the connection between Exago and a database or a web service. Although typically only one database is used, Exago can join data from different sources into a single report.

The Database Settings allow administrators to adjust how Exago interfaces with its Data Sources. Additional type-specific settings allow you to specify which driver to utilize when connecting to each data source.

Add, edit or remove data objects and fields from the ExpressView with the Data Objects pane. This article applies to versions of the application released prior to v2021.1.

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.

Joins specify to Exago the relationship between Data Objects. This article applies to the Admin Console > Data > Joins settings, where joins are defined at the base-configuration level.

Nick Cortina reviews adding complex joins to the configuration and to specific reports. Examples included in this lab will have joins with inequalities, as well utilizing sub queries. Finally, Nick discusses the various mechanisms available to us to apply these joins.