Query Properties

Use the Query Properties dialog box to set properties for the current query.

Table 23. Query Properties

Option

Description

Return Unique Rows

Eliminates duplicate rows from the data set retrieved by the query.

Return First ___ Rows

Filters the number of database rows retrieved to the number entered.

Time Filter ___ Minutes

Filters the amount of time the query is allowed to run to the number entered. Seconds are entered as a decimal number. Time filters work for asynchronous database connections and cancel at the earliest opportunity for nonasynchronous connections.

Auto Process

Specifies the current query as a Standard Query to be processed automatically on download from the Repository (Interactive Reporting Studio only).

Custom Group By

Customizes the Group By criteria used to compute aggregate Request items, with selected items not factored into the grouping. This feature is available only when a data function is placed on a Request item.