Takes long to open report

Question

Takes long to open report

RVO

SSCertifiable

Points: 5495
More actions
October 17, 2013 at 1:06 pm

#278182

When I click on report in Report Manager
it takes 10 sec + to open report.
It is set to run with default parameters and maybe when you click
it is starting to execution but
why it doesn't show me the page right away with a "Loading" spinning wheel?
The user might not be happy about it.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

mktk52 Newbie Points: 6 More actions · Answer 1

When the report is run, it executes all the data sets. This is probably causing the delay. You need to check your queries for the data sets

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 2

I've found that even the fastest queries are slowed down a whole lot by SSRS. I don't know what they do behind the scenes but I'd fire a Developer for writing code that slow just to draw a pretty picture of some data. Heh... I've found that even Access is faster than SSRS.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Mark Fitzgerald-331224 SSCrazy Eights Points: 8489 More actions · Answer 3

RVO (10/17/2013)
When I click on report in Report Manager
it takes 10 sec + to open report.
It is set to run with default parameters and maybe when you click
it is starting to execution but
why it doesn't show me the page right away with a "Loading" spinning wheel?
The user might not be happy about it.

The most common issue I have found to cause this is the use of the Page X of Y page footer. To complete the first page of the report the full report needs to be generated to find the total number of pages.

To spot this issue look at the top of the report (where it has export, print etc). If on a multiple page report it shows 1 of 2? , then it is not the cause but if it have 1 of 200 (substitute any 2+ number) then it has formmated the whole report on the server before showing you the first page.

Fitz