Creating Crosstab Reports in Studio Reports

Applies to: Kyvos Reporting

A Crosstab report summarizes data by showing values at the intersection of row and column groupings. You must select at least three fields from the data source:

Row Heading
Column Heading
Data Field (summary field at the intersection)

Insert a Crosstab in the Layout Editor

On the Kyvos Reporting Studio home screen, go to Insert > Crosstab.
The cursor changes to a crosshair (+). Click and drag in any section of the layout editor to define the area where the crosstab will appear.
When you release the mouse button, a prompt appears asking whether to create a Bound or Unbound crosstab report.
- Click Yes to create a Bound Crosstab report.
- Click No to create an Unbound crosstab report.

Note

In bound crosstab reports, data is scoped to the section and data source of the parent report.
In unbound crosstab reports, the crosstab uses its own data source, and the entire dataset retrieved is considered regardless of the placement section.

Crosstab Report Properties

To configure properties for either bound or unbound crosstabs:

Access the relevant property from the Property pane on the right. These properties are further discussed in the Section and Control properties chapter.

Bound vs Unbound Crosstab Reports

Bound Crosstab

Uses the parent report’s data source and SQL query.
The Data Source properties are disabled (grayed out).
You cannot modify the connection or SQL from the Crosstab properties.

Example:

Crosstab rows and columns are grouped based on the data already fetched by the main report query.

Unbound Crosstab

Has an independent data source and SQL.
The Data Source properties are enabled, allowing you to:
- Select a connection name.
- Write or edit a custom SQL query.
- Choose a predefined query object.

Example:

Use an unbound crosstab when you need to summarize or group data from a different source than the parent report.