Reperting Services report generation slow

[jmk418]

I have a report that uses a stored procedure to call the data. The stored procedure runs in about 1 sec and when I view the data on the data tab in reporting services it takes about 1 sec. However when I try to view the report in the preview tab it takes 3 min or so. But when the report is deployed to the report server and accessed through report manager it only takes a few seconds to display the report. Has anyone else had this problem or have any ideas what might be causing the problem?
Thanks in advance
Jeremy

 

[xlbo]

Preview tab uses a different rendering engine compared to the server - must be something to do with the report rendering rather than the data fetch

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question