In addition to using the data fields that are available in the Data Objects Pane, formulas may be added as custom formula columns. Formulas may contain data objects, parameters and functions. Just like standard columns, a formula column may be either a detail field or group, and may be included in visualizations, formatted, sorted and filtered.

The ExpressView Designer is a data discovery tool that simplifies grouping, sorting, filtering, and aggregating data with a drag-and-drop interface. A chart can be added with a single click, and ExpressViews can be styled and saved as PDF, RTF, CSV, or Excel files. This article applies to versions of the application released prior to v2021.1.

Use this document to understand how the Exago platform works.

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.

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.

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.

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.

There are two report types well suited for building your first report: ExpressView and Advanced Reports. This tutorial provides a step-by-step guide to create a simple ExpressView and Advanced Report for beginners.

In this video we’ll explore formulas, which allow us to modify a given cell’s contents.