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
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
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.