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

1
votes

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

2
reporting-servicesreportingservices-2005
I have test it and found that for the last parameter is i select top 974 then it works fine. but I slection record greater then 974 then I got error message. I think 974 is the limit for multi-value parameter in ssrs 2005 – user999896
I think the length limitation may be related to the length of the string produced ('Value A','Value B',...) so changing the value of your parameters may help slightly. – Jamie F
@Jamie F: Ahh - that would be an interesting thought. A quick calculation shows that if the string is of the form 1,2,3,4 then 1 to 974 would give a length of 3788. I'd not be suprised if the limit was 4000 characters and there're some spaces or something in there. – Steve Homer

2 Answers

1
votes

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.

0
votes

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