Step 1 – Open the Report in "Design" Mode.
Step 2 – Click the "Data Access" tab.
Step 3 – Click "Edit".
Step 4 – Click the "Query Properties" icon.
Query Properties Options
1) Name: The name of the Query. The name can also be changed here
2) Universe: The universe that the Query is built on
3) Restrict Amount of Data Returned
"Max rows retrieved": To select the maximum number of rows for retrieval
"Retrieve duplicate rows": To include duplicate rows. In a database, the same data may be repeated over many rows. You can choose to have these repeated rows returned or or to only have unique rows returned
"Sample result set": To use fixed sampling, call "Fixed".
"Retrieving empty rows": To include empty rows in the results
4) Max Retrieval Time: Select the maximum retrieval time(s) and enter the amount of time in seconds
5) Security: Check off Allows Other Users to Edit Queries for others to be able to edit the Query.
By default, Queries can only be edited by the user who created them
6) Prompt order: Able to change the order that the prompts appear when refreshing the report by clicking the prompt option and navigating using the up/down arrows.
7) Context: If Reset Contexts on Refresh is checked, you need to choose a context each time the Query is run. You will also need to choose contexts if you select the Clear Contexts option.
After selecting Clear Contexts, the next prompt on contexts will still show the last selected context and if you want to select another context, you must first remove the existing selection
Before you schedule a document that contains multiple contexts, you must first select a context