CODEWITHSUNDEEP
reporting-servicesreportingservices-2005
user999896
user999896

Reputation: 129

What is maximum limit of items in ssrs 2005 multi-value parameter

I am using SSRS 2005. I have one parameterised report. I am using 3,4 cascading parameters. my last parameter can have upto 5000 values in it. I want to know that what is the maximum limit of multi-value parameter becuase when i select deselect some parameters I got one error "Operation is not valid due to the current state of the object." I wonder if it is due to lot of values in one of the parameter.

Please guide.

Thanks

Upvotes: 1

Views: 11527

Answers (2)

Andrey Morozov
Andrey Morozov

Reputation: 7979

From here

There is a constraint (on .NET framework or Web server I think) that allows only 1,000 values to be loaded under parameter drop down boxes

Upvotes: 1

Steve Homer
Steve Homer

Reputation: 3922

I can't find a source for a hard limit of number of parameters but to be honest if you're using 100s I think you're going to run into usability issues first.

I'd suggest grouping the options by one or two more cascading parameters that narrow down the range if that's possible for your application.

Upvotes: 2

Related Questions