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

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