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

Advertisements

About Joseph Velliah
As a SharePoint Developer my professional interests tend to be technical and SharePoint focused. I run a blog at "SP RIDER" where you can expect to read HOW TOs and scenarios that I run into during my day to day job. I hope my posts will give back a little to the community that is helped me.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: