How to improve performance of Reports?

I HAVE REPORT WITH SEVERAL GROUPS AND FIELDS
ITS RUNNING VERY SLOW
I AM EXTRACTING EVERYTHING FROM 1 TABLE ONLY
HOW CAN I IMPROVE PERFORMANCE OF THE REPORT
CAN ANYONE FROM MICROSOFT LET ME KNOW ALL PERFORMANCE OPTIMIZATION TIPS AND TECHNIQUES FOR THIS TOOL

You'll have to be more specific:
1. How long does it take to get the data from the SELECT statement?
2. How long does it take to export the data as XML (RDL processing, from what I understand)?
3. What is the final output format? We are currently have performance problems with large PDF
reports.

I would love to see some tips for performance as well!

Jami

Take a look at this
http://blogs.msdn.com/tudortr/archive/2004/06/28/167969.aspx

--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.

AND TECHNIQUES FOR THIS TOOL

We definitely need more information. This should not be a problem at all (at
least from a complexity viewpoint).

Bruce L-C

AND TECHNIQUES FOR THIS TOOL

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

1 17th July 02:31 raje¨ÝŠÇ.²È¨žÉ¢rº,¡û\¢ External User Posts: 1	How to improve performance of Reports? I HAVE REPORT WITH SEVERAL GROUPS AND FIELDS ITS RUNNING VERY SLOW I AM EXTRACTING EVERYTHING FROM 1 TABLE ONLY HOW CAN I IMPROVE PERFORMANCE OF THE REPORT CAN ANYONE FROM MICROSOFT LET ME KNOW ALL PERFORMANCE OPTIMIZATION TIPS AND TECHNIQUES FOR THIS TOOL

3 25th July 02:16 tudor trufinescu \(msft\) External User Posts: 1	How to improve performance of Reports? Take a look at this http://blogs.msdn.com/tudortr/archive/2004/06/28/167969.aspx -- Tudor Trufinescu Dev Lead Sql Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. AND TECHNIQUES FOR THIS TOOL

4 25th July 02:18 bruce loehle-conger External User Posts: 1	How to improve performance of Reports? We definitely need more information. This should not be a problem at all (at least from a complexity viewpoint). Bruce L-C AND TECHNIQUES FOR THIS TOOL