.NET Hawa

Problem With SSRS MultiValued Parameter

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 comment »