How to improve the performance of a Report?

[DiGzâ„¢747]

Hi Guys,

I would like to ask for some tips on how to improve the performance of a report in report studio.  The thing is, we have two reports that are long running most of the time.  Its even timing out due to its long running.  What should I modify in order to resolve this issue?

Any help from you guys will be much appreciated.

Thanks,
DiGz747

[vijayab]

Hi DiGz747,
Even same question i had,I separate out the Queries as much as possible
like previously i had 2 Queries in my report then i separates them into 6
e.g.
1)Query A into Query_iA and Qurey_iiA
and joined them and make Query_i_ii_A

2)Query B into Query_iB and Qurey_iiB
and joined them and make Query_i_ii_B

this helps me a lot to improve my Report Performance

also u can apply following ways too.....
Select the Query and go to the properties Pane
and Set
1)Processing as LIMITED LOCAL
2)Use Local Cache as YES


hope this might be useful for u .. :)


Thanks,
vijyab

[Suraj]

One important thing to check is calculated items.
Make sure they are properly aggregated and where possible use a for clause to force aggregation in the way you want.