Exceeding length of multivalue string parameter

[willcas]

Hi all,

I've run into a problem with a multivalue string parameter that feeds to a stored proc via SSRS 2005 in that if I choose All from the drop down then I only get partial results (up to letter G ). I have calculated the length of the parameters to be about 1750 characters plus commas. If I feed the stored proc the full list from the param dropdown in SQL EM then I get the full set of results.

My questions are

1, Have I read the problem correctly ?

2, Is there a max length to a string parameter even if set to multivalue?

3, How can I get around this limitation.

TIA

Will

 

[onpnt]

The problem I think you are running into is a URL will only allow 2083 characters so it is probably being truncated there and not other places.

POST is not limited and you'll need to go that route.

I found this for you to review

http://blogs.msdn.com/bryanke/pages/73153.aspx

This would be much easier to control I think if you could control the report in .NET creating it programmatically by creating a custom assembly for it
ie.

http://support.microsoft.com/kb/920769

[sub]____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]