limiting the # of choices for a multiple value parameter

[swhitten]

The user wants a parameter that allows them to choose multiple values, but they want to limit how many can be chosen. I know how to set up a parameter that is either False on Allow Multiple Values or True on Allow Multiple Values, but if I set it to True, I don't know how to restrict how many they can select. Example: If we want to report on one to three zip codes, I have a dynamic list of all the zip codes. The zip code parameter allows multiple values. How can I restrict it so they can ONLY include one to three, no more than three zip codes when they run the report? Thanks!

 

[IdoMillet]

Can't do this upfront, but you can check the count and abort (using a record selection formula that ensures the count of elements in the parameter array is below N).

You can also display (un-suppress) a text object indicating the violation

- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[swhitten]

Great idea! Thanks!