Tuesday, April 27, 2010

Crystal Reports : Displaying Parameters on your Report (Part 2)

The second instance of a multiple value Parameter is the "list" based string. This is done by checking the "Allow Multiple Values" checkbox within your Parameter properties window. This will allow the end user to add multiple items to a list.

Our parameter: {?Salesperson}

You'll notice that if you simply drag this parameter onto the report, it will only give you the first item in the values list.

You must create a formula called {@Salesperson_List} and insert the following text:

JOIN({?Salesperson}, ", ")

The JOIN function will spit out every value in the list, delimited by the comma. Notice the space after the comma as it looks crowded otherwise. Try it!

No comments: