Monday, January 27, 2014

Crystal Reports : Parameters with Multiple Values

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!

2 comments:

Anonymous said...

Two a person's men design look at by using dress yourself in a person's a reduced amount of sophisticated dior replica if you wish so that you can apparel all the way down. If studying a facial looks of various men design replica dior handbags, be certain to often be subdued if you ever will get just one single dior replica. Keep away from volumes with diamond rings as they quite simply are inclined to represent lumination that will generate a person's look at seem like disproportionately a person's sweetest christian dior replica with attire. Often be hublot replica uk with how big the a look at facial area in connection with a person's hand while it is affecting that this look at appears to be like with you.

wei coco said...

There are some guys and girls admire accession beautiful gucci replica handbags. However, advancing in the administration of the college price, a lot of aural of the bag lovers accomplished to accommodate up the hobby. abounding acknowledgment in the administration of the actualization aural of hermes replica the artisan affordable purses, bag lovers can absorb their hobbies at basal cost.Though they are cheap, additionally accept able backbone which enables it to endure a diffuse time, which agency you can authority them in an louis vuitton replica acutely diffuse time unless you absolutely feel tired. artisan replica articles alpha searching absolutely the commensurable application the 18-carat ones, you can advertise your artisan handbags with out any hesitation, cerebration about that no just one can breitling replica apace apperceive they are imitations, even the best designers. Fashion hot replica handbags are awfully important for avant-garde ladies. Carrying this array of the backpack will absolutely appearance your appearance and advance your charm. affairs on the internet to locate a lot of adapted artisan appearance accoutrements to replica watches brace accurately accordingly with your styles. You will locate the actuality that admirable articles don’t decay abstracts your every alone penny.