question

muk avatar image
muk asked

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.
sql-server-2008sql-server-2008-r2ssrsreporting_services
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Usman Butt avatar image
Usman Butt answered
The best way to troubleshoot is to look into [Reporting Services Log Files][1]. Moreover, make sure that Reporting services are running ;) [1]: http://msdn.microsoft.com/en-us/library/ms157403%28v=sql.105%29.aspx
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

muk avatar image muk commented ·
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!!
0 Likes 0 ·
Pavel Pawlowski avatar image Pavel Pawlowski commented ·
And also a good source of information related to the execution of report is a [ExecutionLogStorage] table in the Report Server Database.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.