SSRS Deployed reports have disabled parameters in IE, and those without parameters just return a blank screen

Question

I have a set of SSRS reports developed in Visual Studio Data Tools that are used for several clients.

For one particular site, each report will work perfectly in 'Preview' mode in Visual Studio, however when I deploy them and attempt to run them in IE all of the parameters are disabled/greyed out. I also tried to put in a set of default parameters to see what would happen and when I click 'Run Report' I do not even get the 'Loading' image and the report is just blank.

I have checked the IE security settings and have reset them, and also added the report web page location in to trusted sites which unfortunately hasn't made a difference. One thing I have also noticed is that when I try to view Developer Tools in IE, it also just shows a blank white screen.

I've searched online and found a couple of old posts on various websites with a similar issue but none that were ever resolved, and now I am not sure how to proceed.

More info that might be useful: The client are using IE 11, it is a terminal server style setup with around 8 or 9 users logged on. The report I am testing with has 2 date parameters first, and two multi-valued parameters (I have tried other reports but with the same issue) The client recently moved servers and the reports worked fine before, although it was a fresh install of the report so I don't believe there would be any old settings that could be causing it?

Any help greatly appreciated :)

Answer 1

In SSRS, report parameters can be inactive when the report is generated from a snapshot. Removing this option is as follows:

1. Navigate to the report in SSRS
2. "Manage" the report from the drop down.
3. Select "Processing Options" from the left menu
4. Is "Render this report from a report snapshot" selected? If so, switch to "Always run this report with the most recent data" option.
5. Run the report to determine if parameters are now active.

If this fixes your issue, you may need to switch from the snapshot option to the Scheduled Cache option available under the left menu link "Cache Refresh Options"

Answer 2

For one particular site, each report will work perfectly in 'Preview' mode in Visual Studio, however when I deploy them and attempt to run them in IE all of the parameters are disabled/greyed out.

If that is the case, and a previous version of the report was already on the SSRS report server, what you can do is delete the report, and upload it again. There is some kind of cache for the parameters, that causes that if you modify the order of them, some get disabled, and the only way I have found to get rid of it is to delete the old report from the server.

Answer 3

For me this worked:

• Open IE
• Go to Settings->Compatibility View Settings
• Add the URL of your report server.

Answer 4

You could be experiencing an old bug which was reported a long time ago in a connect item:

• SSRS Weird Parameters Order Bug (parameter grayed out)

The official Microsoft answer on this subject is:

Currently this behavior is per design. However we will consider this behavior improvement in a future release of reporting services The only workaround at this point is to change the order of the parameters.