.NET Hawa

Problem With SSRS MultiValued Parameter

on December 19, 2013

In SSRS 2008, some times multi – valued parameter drop down will fire selection event at “Select All”.  Solution is,  first please check the drop down first how many records it is handling if they are < 970, it is your data set fault. Your drop down is handling greater that 970 records it is a rule give by Microsoft guys to handle only 1000 records by default, as asp.net http requests.  Solution for this is, please add below tag to <appsettings> in your report manager web config file.

<add key=”aspnet:MaxHttpCollectionKeys” value=”[yourno.]” />

you can find report manager in sql server instance installation directory


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: