Defining Data Source for Studio Reports Crosstab
Applies to: Kyvos Reporting
Use the Data Source properties to define the database and query that supply data for your crosstab report.
Data Source Options
Option | Description |
|---|---|
ConnectionName | Select the required connection to fetch the data. |
SqlQuery | Click the three dots Actions menu to specify SQL query. |
Query Object | Select a predefined query object (QO) as the data source. |
Select Query | Choose from a list of available query objects stored in the repository. |
Specify SQL | Manually define the data source by entering an SQL query and selecting the required fields. |
SQL Configuration
If using Specify SQL:
Connection: Select a database connection from the list of previously defined connections. Crosstab reports also support OLAP-type connections.
SQL Query: Enter a valid SQL query that retrieves the required data for your report.
Available Fields: Displays fields returned by the SQL query.
SQL Designer: Opens a visual query editor for designing SQL by drag-and-drop or direct input.
Note
When accessed from Crosstab Properties, the Sort and Filter tabs are disabled.
Field Options
Action | Description |
|---|---|
Verify SQL | Checks the SQL syntax and refreshes the list of available fields. If you switch to another tab and return, only the selected fields will remain listed unless refreshed. |
Field Properties | Opens the Field Properties dialog box to view or edit field-level settings. |
Selection Window
The Selection Window shows the layout of the crosstab. To define data areas:
In the Selection Window, choose a target area:
Column Header
Row Header
Summary Field
From Available Fields, check the columns you want to place in the selected section.
This step binds the selected data fields to the corresponding part of the crosstab layout.