locked
SQL Server limit on the number of multivalue parameter selections? RRS feed

  • Question

  • I have over a 1,000 possible selections for the parameter in the SSRS 2008 R2 (integrated mode) report.

    One is an "all offices" option which equates in logic to the "select all" option -- works fine by the way.

    Here's the issue:

    • If the user selects "select all" and hits apply, no report is shown -- the "apply" button goes grey for awhile then goes back to black, but no report is shown
    • If the user selects a few offices and hits apply, the report is shown

    What appears to be going on is that SSRS cannot handle passing a multi-valued parameter if that parameter contains a very high number of selections/items.

    One workaround is to go to a cascading filter/parameter, but if anyone has also seen this SSRS problem with a large number of multivalue selections I'd be interested in your experience/workarounds.  Thanks, comments welcome.

    Monday, December 2, 2013 3:22 PM

Answers

  • Hi Bob,

    Microsoft security update MS11-100 limits the maximum number of form keys, files, and JSON members to 1000 in an HTTP request. Because of this change, ASP.NET applications reject requests that have more than 1000 of these elements. HTTP clients that make these kinds of requests will be denied.
    To resolve the issue, we can modify the web.config file of the Report Manager (Native mode) or the SharePoint site (SharePoint Integrated mode) as follows:

    <appSettings>    
    <add key="aspnet:MaxHttpCollectionKeys" value="10000" />
    </appSettings> 

    Reference:
    An ASP.NET request that has lots of form keys, files, or JSON payload members fails with an exception

    Regards,
    Heidi Duan

    If you have any feedback on our support, please click here.


    Heidi Duan
    TechNet Community Support


    • Edited by Heidi-Duan Tuesday, December 3, 2013 8:21 AM edit
    • Marked as answer by Bob Harford Tuesday, December 3, 2013 10:45 AM
    Tuesday, December 3, 2013 8:20 AM

All replies

  • Hi Bob,

    Microsoft security update MS11-100 limits the maximum number of form keys, files, and JSON members to 1000 in an HTTP request. Because of this change, ASP.NET applications reject requests that have more than 1000 of these elements. HTTP clients that make these kinds of requests will be denied.
    To resolve the issue, we can modify the web.config file of the Report Manager (Native mode) or the SharePoint site (SharePoint Integrated mode) as follows:

    <appSettings>    
    <add key="aspnet:MaxHttpCollectionKeys" value="10000" />
    </appSettings> 

    Reference:
    An ASP.NET request that has lots of form keys, files, or JSON payload members fails with an exception

    Regards,
    Heidi Duan

    If you have any feedback on our support, please click here.


    Heidi Duan
    TechNet Community Support


    • Edited by Heidi-Duan Tuesday, December 3, 2013 8:21 AM edit
    • Marked as answer by Bob Harford Tuesday, December 3, 2013 10:45 AM
    Tuesday, December 3, 2013 8:20 AM
  • Heidi,

    Worked perfectly, thanks so much.

    --Bob

    Tuesday, December 3, 2013 10:45 AM