SSRS 2008 R2 Report hangs
Hello, I have a report with 8 parameters. Only the second one depends on the first. When I make a selection form the first drop down, it disables all the rest of the parameters. This does not happen in BIDS or when I run the application locally. Any ideas. Thank you, Howard Katz
August 9th, 2012 5:17pm

Hi There Thanks for your posting. Do you have any default value set for second parameter. Please try to set default values for second parameter which is cascading parameter. If that does not help. Please try to change the order of the parameters and see if it makes any difference Many thanks Syed Qazafi Anjum
Free Windows Admin Tool Kit Click here and download it now
August 9th, 2012 6:27pm

Hi Syed, I did set a default for the second parameter and it still hangs. In advanced options I set it to refresh always. The real confusing thing is if i run it directly in the Report Manager it works fine. If I run it from the asp.net 4.0 C# application if works fine. In both cases, I am attaching to the same Report Server. Where it is failing is when I copy the application to our Staging server it gets to the report but when I select an item from the first parameter, all other parameters are disabled. Thanks, Howard
August 10th, 2012 8:40am

Hello Howard, Thank you to post your question on TechNet forum. I want to check whether you installed the latest report viewer control on the staging server, and whether the application pool for the application on the staging server is configured as .net framework 4.0. If you still have the problem, please provide more information, such as the version number of the report viewer, etc. Regard, EdwardEdward Zhu TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
August 13th, 2012 6:12am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics