The Octiv Report Builder allows you to select from three view types:
- Tables, which are used to view values in the database and to summarize the values in columns
- Charts, which compare one or more measures across multiple sets of related fields.
- Crosstabs, which aggregates data across multiple dimensions. This section provides an overview of each view type.
The architecture of a table view consists of columns, rows, and groups.
Columns in a table correspond to the columns in the data source. They are included by adding fields or measures to the table in the Report Builder view.
Rows correspond to rows in the database. The information in each row depends on what columns are included in the table.
Using groups, rows can be grouped by identical values in any field with intermediate summaries for each grouped value. For example, a table view of product orders might contain columns to show the dates and amounts of each order, and its rows might be grouped by city and product.
Charts summarize data graphically. Types of charts include bar chart, line chart, and pie chart, among others. With the exception of time series and scatter charts, each type of chart compares summarized values for a group. For example, the Chart tab might show the data in a bar chart that compared the sum of Payments Received for each of the products in each of the cities.
Time series and scatter charts use time intervals to group data.
Crosstabs are more compact representations than tables; they show only computed values, rather than individual database values. Columns and rows specify the dimensions for grouping; cells contain the summarized measurements. For instance, the example above could be displayed in a crosstab with columns grouped by sales manager and year.
Did this article help?
Please provide us your feedback below.