How to restrict user to select only 3 values from the multi value parameter – SSRS

Requirement

How to restrict user to select only 3 values from the multi value parameter – SSRS?

Solution

To take the count of the number of items selected in your parameter use the below expression in your hidden parameter

=Parameters!ParameterName.count

Based on the count in the hidden parameter you can check the condition and pop up the error message. Follow this article written by me

http://www.innovativerndlab.blogspot.com/2009/04/displaying-pop-up-message-in-ssrs-2005.html

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.