Advanced Properties
Applies to: Kyvos Reporting
Advanced properties allow you to fine-tune the behavior of a Query Object and the reports generated using it. These settings override global or connection-level configurations where applicable.
To configure these properties, click Advanced from the Actions menu.
Advanced Property Definitions
Property | Description |
|---|---|
Audit Log | Controls audit logging for reports generated using this Query Object, independent of the global setting. Options: Default, Enable, Disable. |
Run Priority | Determines this Query Object’s execution priority in the Report Server queue. Options: Default, Low, Medium, High. |
Database Connection Timeout | Overrides the database timeout setting defined at the connection or global level. |
Data Source Fetch Size | Overrides the fetch size configured at the connection or global level. |
Max. Rows | Defines the maximum number of rows this Query Object can return. The report-level setting can further reduce, but not increase, this limit. |
Query Execution | Specifies how the query should execute. Use Asynchronous to free rendering threads during long-running database operations. Options: Default, Synchronous, Asynchronous. |
Restrict To Background | Restricts reports using this Query Object to run only in background mode. Useful for resource-intensive queries. Options: Enable, Disable. |
Restrict To Formats | Limits report formats allowed when using this Query Object. Useful for controlling export behavior with large result sets. |
Default Memory Usage Per Exec | Overrides the memory usage value per execution at the connection or global level. |
Report Server Chunk Timeout | Sets the chunk timeout value for large data operations. Overrides connection or global configuration. |
Sort Area Size Per Exec | Defines the number of records that can be sorted in memory. Overrides the connection or global level setting. |
Sort Threads Per Exec | Specifies the number of threads to be used for in-memory sorting. |
Data Caching | Enables or disables local caching of Query Object data for use in in-view and post-view report operations. |
Update Fields At Runtime | Enables detection and inclusion of new fields returned at runtime by a dynamic SQL or stored procedure. These fields are not saved permanently in the Query Object. |
Data Caching
When Data Caching is enabled, a cached copy of the Query Object result set is stored in a local data store. This is reused for the following in-view or post-view operations:
Applying or modifying filters
Adding or editing highlights
Adjusting grouping or sorting
Adding/removing charts or matrix elements
Fetching lookup values derived from the main dataset
Note
Data cache remains available until purged based on the DATA_CACHE_PURGE_TIME property (default: 30 minutes)
Caution
Avoid enabling Data Caching for Query Objects returning large unfiltered datasets, as the initial execution may be slow.
For dynamic SQLs with changing fields, caching may result in incorrect results. Enable Data Cache only for Query Objects with static field structures.
Update Fields at Runtime
This setting allows the Query Object to include new fields returned by dynamic SQL or stored procedures (e.g., SELECT *) during execution. These fields are made available temporarily at runtime but are not saved to the Query Object definition.
Caution
Enabling this setting may require additional executions of the Query Object during runtime, which could impact performance.
Use this setting when field structure may vary, but ensure performance requirements are met.