SSRS Expanded reports disabled parameters in IE, and those without parameters simply return a blank screen

Question

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

For one specific site, each report works fine in the "Preview" mode in Visual Studio, however, when I deploy them and try to run them in IE, all options are disabled / grayed out. I also tried to set a default set of parameters to see what would happen, and when I click Run Report, I don’t even get the Download image, and the report is just empty.

I checked the IE security settings and had reset them, and also added the location of the report webpage to trusted sites, which, unfortunately, did not change the situation. One thing that I also noticed is that when I try to view developer tools in IE, it also just shows a blank white screen.

I searched the Internet and found several old posts on different sites with a similar problem, but none of them were resolved, and now I’m not sure how to proceed.

Additional information that may be useful: The client uses IE 11, this is a terminal server style setting with 8 or 9 users. In the report that I am testing, there are first two date parameters and two multi-valued parameters (I tried other reports, but with the same problem) Recently, the client moved the servers and the reports worked fine earlier, although this was a new report setup, so I do not believe What would be the old settings that could cause it?

Any help is much appreciated :)

Answer 1

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

• Go to SSRS report
• Manage the report from the drop-down list.
• Select "Processing Options" in the menu on the left.
• Is "Display this report from report snapshot" selected? If so, switch to Always run this report using the most recent data.
• Run the report to determine if the parameters are active.

If this fixes the problem, you may need to switch from the snapshot to the Scheduled Cache option, available on the left side of the Cache Refresh Options menu

Answer 2

For me it worked:

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

Answer 3

You may encounter an old error that has long been reported in the connection element:

• SSRS Weird Parameters Order Bug (gray parameter)

Microsoft's official answer on this topic:

This behavior is currently design dependent. However, we will consider this improved behavior in a future release of Reporting Services only a workaround at this point is to reorder the Options.

Answer 4

For one specific site, each report works fine in the "Preview" mode in Visual Studio, however, when I deploy them and try to run them in IE, all options are disabled / grayed out.

If so, and the previous version of the report was already on the SSRS report server, then you can delete the report and download it again. There is a cache for the parameters, which leads to the fact that if you change their order, some of them will be disabled, and the only way to get rid of it is to delete the old report from the server.

Answer 5

Whether the parameters in the RDL file are visible, as shown below:

Answer 6

I just want to add this as an answer because it solved the problem for me; Delete the report on the server and deploy it again.

What happens is that you completely delete the report and therefore also its parameters. When you deploy a report, its default settings are not replaced if it was not set by default during the first deployment.