Report with Many Filter Parameters Will Not Run or Cannot Set All the Filters

Error Description

Some of the reports such as the Quality Detail report have many filter parameters and many items within each filter can be selected. While selecting the multiple filters, the report will appear to freeze or take very long to load the filter list for a parameter.

Reason

In some cases, the total length of the parameter list exceeds the default length set by SQL Server Reporting Services.

Resolution

The length of the parameter request must be modified in the SQL Server Reporting Services web.config files. The files are located in the ReportManager and ReportServer folders under the Reporting Services folder. Open the files and make the following modification:

<httpRuntime maxRequestLength="2097151" executionTimeout="9000" />

Once the setting has been changed, restart the SQL Server Reporting Services service.