Data Analysis and Reporting with Intelligence Clients

Report Section Elements

The Report Section differs slightly from other sections in order to provide you with as robust a report designer as possible. Key differences include:

Expression Line – Accessed via the Expression button on the Section title bar, the Expression line enables you to build common computed expressions using JavaScript.
Catalog Pane – Contains all of the of drag-and-drop elements you use to create a custom report, including:
Query – Contains all the sections associated with a selected query, including Results, Pivot, and Chart sections. You can drag individual Results columns from the Results and Table sections to a report page, as well as entire Pivot and Chart sections to create Smart Reports.
Graphics – Contains standard vector graphics text labels, and pictures (bitmaps only). Vector graphics include line, horizontal line, vertical line, rectangles, round rectangles, and ovals. For vector graphics, choose ReportInsert Graphics. For bitmaps, choose ReportPicture.
Fields – Contains predefined fields that can be dragged to various areas of the report to enhance the look and feel of the report. Fields include items such as date and time, the report name, or page number.

To use any of these elements, simply drag them to the desired report component band.

Outliner – Consists of the Groups Outliner and Table Outliner. The Table Outliner is divided into the Dimension and Fact panes.
Groups Outliner – Defines the overall or highest levels used to group data in a report. When you designate an item to serve as a group header (also known as a break value), you are instructing Intelligence Clients to organize the rest of the data in repeating collections of records according to the group header.
Dimensions Pane in Table Outliner – Includes descriptive information such as a column in a table that is included in the body of the report.
Facts Pane in Table Outliner – Includes the measurable or quantifiable data as a column in a table included in the body of the report. Intelligence Clients automatically calculates and inserts subtotals for each fact column.

values by group header and dimension. If you have a descriptive numeric value that should not be calculated, such as Retail Price or Target Sales, use it as a group header or table dimensions instead of a fact.