SSRS report hanging

Hi all, I have a simple report I created in SSRS with one parameter. When I preview it in BIDS it works fine and really fast but when I try to run it on the report server I click apply for the parameter and nothing happens it just hangs. The apply button flickers but the screen never changes. Is this a bug? Has anyone encountered this before? Thanks.

asked Aug 07 '12 at 09:48 PM in Default

muk
300 ● 8 ● 23 ● 26

(comments are locked)

1 answer:

The best way to troubleshoot is to look into Reporting Services Log Files. Moreover, make sure that Reporting services are running ;)

answered Aug 08 '12 at 05:27 AM

Usman Butt
13.8k ● 6 ● 8 ● 14

Thanks @Usman! I realized that my dataset for my parameter was returning over 5000 rows so I had to change it to a text box instead of a drop down and that seemed to do the trick. Thanks!!

Aug 08 '12 at 02:56 PM muk

And also a good source of information related to the execution of report is a [ExecutionLogStorage] table in the Report Server Database.

Aug 08 '12 at 08:05 PM Pavel Pawlowski

(comments are locked)