Monday, June 4, 2012

Crystal Reports : Parameters with Multiple Values

This keeps coming up with clients. Being able to use multi-value parameters (where the end user build a list instead of just choosing a single value is awfully handy, but printing the list on the report isn't as easy as you might think.

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:

wei coco said...

Therefore accomplish abiding you accept bright objectives and goals for
breitling replica your centralized networking that will adviceb all parties. Botkier Chrystie Zip Hobo Bag Botkier Chrystie Zip Hobo Bag Botkier about is one of those who plan in gucci replica the account because they consistently advance items that is a part of a kind. This colossal Chrystie Zip hobo is one of the proofs from this. Striking the scales for $695, it is created from shimmering Italian covering with snake-stamped lambskin askew detail, and brownish accouterments and replica handbags studs accentuating the accomplished piece. Additionally, it appearance bifold askew zip closures with anniversary featuring its compartments. The 2 interiors are lined with logo lining, which aswell cover one central zip, a adaptable buzz pocket, a multi-functional abridged with keychain, as able-bodied as an autogenous logo plate in commendations to the covering platform. Measuring about 16H x 2D x 17W usa replica watches, this Botkier hobo bag is ample abundant to accept accustomed accidental use, with appearance and composure available. Apart from brownish usa Louis vuitton, the bag is aswell accessible in smoke and black/black snake. Even admitting snake detail is not abundant visible, still enhances the allure and breeding of the louis vuitton replica.





林磊 said...

2016-2-20 leilei
kate spade outlet
new balance shoes
adidas gazelle
louis vuitton purses
cheap ugg boots
michael kors handbags
canada gooses outlet
nike uk
michael kors outlet
louis vuitton outlet
louis vuitton handbags
coach factory
mcm handbags
cheap oakley sunglasses
mont blanc pens
michael kors bags
nike tn pas cher
fitflops shoes
ghd hair straighteners
longchamp pas cher
nike shoes
canada goose jackets
michael kors bag
hermes belt
timberland uk
adidas running shoes
ugg boots australia
christian louboutin outlet
air max 90
fitflops sale clearance
true religion sale
burberry outlet online
ed hardy uk
louis vuitton
michael kors uk
nike air max 95
coach outlet online
michael kors outlet
oakley outlet
fitflop sale