Home Forums Reporting Services Reporting Services 2008 Development Report does not execute stored procedure RE: Report does not execute stored procedure

  • November 1, 2017 at 12:47 pm

    #1966272

    den.j.stevens - Wednesday, November 1, 2017 11:37 AM

    A-ha. I googled ThrowIfMaxHttpCollectionKeysExceeded() and saw what some others have found. I have parameters which - if the user 'selects all' - results in lots of parameters. When I re-ran by deselecting the 'select all' the report runs fine.

    But that doesn't really fix the problem, as other users could still select 'select all'. Sounds like you haven't set up your SP to accept multi-value parameters, or the report shouldn't be set up to permit them

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk