balajishriram

• Aug 5th, 2011

 

We can Improve the performance of reports in Report Studio with the help of following points :

1. We should create indexes on tables
2. We should avoid using FULL outer joins if possible....
3. We should use 'IN' operator instead of 'OR' while filtering the reports.

These are few performance tuning techniques for reports in Report Studio.

shailendra32

 Profile Answers by shailendra32 

• May 26th, 2012

 

There are few points -

1) If you need one parameter in your report then use equal to (=) in place of in.
2) In Framework manager -> Governor -> allow usage of local cache.
3) In Report Studio -> Query Properties -> allow usage of local cache.
4) Use more filter in report.
5) Give full reference of the data Item in the filter so it will take less time.