Configuring Data Source for Studio Reports Charts
Applies to: Kyvos Reporting
The Data Source tab allows you to configure how data is fetched and used in an unbound chart. You can perform the following activities:
Set up connection details.
Retrieve data using SQL or predefined queries.
Select and format fields to be plotted on the chart.
Setting Connection Details
Use the options below to configure the data source and runtime connection preferences:
Property | Description |
|---|---|
Connection Name | Select a predefined connection to retrieve chart data. |
Select Query | Choose a predesigned query from the repository. Use the dropdown to navigate to the relevant folder. After selection, click Verify SQL to display the SQL in the SQL Query box. |
SQL Query | If no query object is selected, manually enter a valid SQL query here. Click Verify SQL to check for syntax errors. |
SQL Editor | Opens the SQL Editor dialog to create or edit the SQL query. Queries created here will appear in the SQL Query field. Note: Sort and Filter tabs are disabled when accessed from this screen. |
Verify SQL | Validates the SQL syntax and refreshes the available fields retrieved by the SQL. Use this after switching tabs to reload field definitions. |
Runtime Connection Options
Choose the connection to be used at runtime for fetching data:
Option | Description |
|---|---|
Use Parent’s | Uses the same connection as the parent report. |
Use Engine Default | Uses the default connection configured in the Kyvos Reporting Report Engine Connection Manager. |
Use Named | Select a specific named (configured) connection to override the default. |
Note
Unbound charts can also use Kyvos Reporting-type connections for data retrieval.