Tuning Reports in General

In general, I used to follow these steps for tuning in reporting level.

In Query Properties:

• If you are using multiple queries associated with layout then set “Execution method as Concurrent”
  By default Execution method will be sequential ,Hence every query will executed one by one. Setting sequential to concurrent, Query will executed concurrently (parallel) and it won’t wait until first query’s execution.

Note: It doesn’t mean setting Execution Method to Concurrent will always gives better performance! , It may vary with peak/Normal hours & some cases will give better performance on setting the sequential .This will depends up on the Number of queries, joins, etc… Used and associated with layout.

• If you having prompt page separately in report then set ” Parameter info as Yes” for queries those associated with the prompts & set ” Parameter info as No” for the remaining queries.

By default it will be yes, so when validating/Running the report all the queries were referred/Checked (Prompt & Report page) for unnecessarily. By setting appropriate setting for queries will improve the performance.

Note: This Property Change will effective when prompts are in prompt page rather than report page.