Number of Multi Value Parameter Values
I have a report with 2 date parameters and 5 multi value parameters. The number of available values are (39,533,614,19 and 37) about 1240 when all the multi value Parameters are combined. If I choose just one or two values on the first parameter and then select all on the other parameters and click the view report button, the report starts but stops and is in the state of just before the view report button is pressed. Clicking the button again has the same results. If I change one of the other parameters to just one or two values the report runs and completes. It appears that there is a limit on how many total parameter values the report will accept. When I run the report in Visual Studio it works correctly. I am using 2008 R2. Any ideas?
June 27th, 2012 3:50pm

Hi There I think you can change the value MaxHttpCollectionKeys, the default value of MaxHttpCollectionKeys is set to 1000 i think. You can override the value by adding the following key to the appsetttings section in your SSRS report manager web.config file (usually in Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager) <add key="aspnet:MaxHttpCollectionKeys" value="20000" /> <add key="aspnet:MaxHttpCollectionKeys" value="20000" /> 20000 is just a quick suggestion for you, you can set it to the value of you would like. for more details please see this thread http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/cb6ede72-6ed1-4379-9d3c-847c11b75b32 http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/89ca7b3d-80f1-4a4f-b8c7-df1f377132e3/ If you have any question please let me know. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
Free Windows Admin Tool Kit Click here and download it now
June 27th, 2012 4:27pm

This solved the problem, the customer has faith in SSRS again. Thanks for the help.
July 4th, 2012 2:05pm

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

Other recent topics Other recent topics