1. Open the Report in Design Mode 
  2. Click the Data Access tab
  3. Click Edit 
  4. Click the Query Properties icon 

Query Properties options:

  1. Query 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
Did this answer your question?