Sorting at Runtime

Applies to: Kyvos Reporting

Use the Sort tab in SQL Designer to define sorting options that users can configure at runtime.

Properties

Prompt: Select this option to display a Sort dialog at report runtime. Users can define their sort preferences in this dialog.
Count: Set the number of sort levels users can select at runtime. For example, to allow sorting by Country, State, and County, set this value to 3.
Qualifier: When writing SQL in the Edit tab, field names may not be prefixed with table names. In such cases, use this field to associate a selected field with its corresponding table. This helps resolve ambiguity if the same field name exists in multiple tables.
Disable Forced Sorting: By default, if the result set from the data source is not sorted as required (e.g., for grouping), Intellicus will sort the data server-side. Select this checkbox to disable server-side sorting and use the data as received.

Important

Server-side sorting can be resource-intensive for large datasets. In such cases, it is recommended to select Disable Forced Sorting and avoid enabling the Prompt option.

Managing Sort Fields

Available Fields: Displays fields fetched from the database.
Selected Fields: Displays fields made available for sorting at runtime.

Use the following actions to manage fields between the two lists:

Click > to move a selected field to Selected Fields.
Click >> to move all fields to Selected Fields.
Click < to remove a selected field from Selected Fields.
Click << to remove all fields from Selected Fields.

Default Sort Order

Based on the value set in the Count field, dropdowns will appear at runtime for users to select sorting fields and order (ascending or descending).

Use the Default Fields section to predefine the sort field and order.
Press Enter in the last row to add a new row.
Click the x icon to delete a row.
Use the Up and Down arrow buttons to reorder the fields.

Completing the Process

Click OK to save your sorting configuration.
Close the report. A prompt appears asking whether to save the design changes.
- Yes: Saves the report with the current design. You can further modify and publish the report using other controls available in Intellicus Studio.
- Cancel: Discards all changes and exits the configuration.