Thursday, May 20, 2010

Crystal Reports : Viewing the list inside a "multiple selection" parameter

This is a blast from the past, but came up recently during our last Crystal training presentation. How to print the values inside a parameter that allows the user to select multiple items?

Let us suppose we have a parameter field; {?UserID}, which allows the end user build a list of Users to report on.

Create a formula called {@UserList} and paste in the following code:

JOIN({?UserID}, ", ")

The JOIN function in crystal will "join" all the multiple values together into a string for us, using the second parameter as a delimiter; in this case a comma.

Try it out!

No comments: