Crystal Reports Tips and Tricks – Listing Selected Parameters
If you have a prompt in your Crystal Reports (known as a “parameter”) which can have multiple selections, you can list these selections on your Page Header.
To list them in a column (remember to mark the field as Can Grow), use a formula such as (sample assumes String type parameters):
@ParameterList = join (?Parameter, chr(10) & chr(13))
To list them horizontally, separated by commas, use a formula similar to this:
@ParameterList = join (?Parameter, “,”)
In either case, place the @ParameterList formula in your Page Header.
For Ranges, you may list the starting and ending range points by creating formulas as follows:
@Start = minimum(?Range) and @End = maximum(?Range)
Again, put the @Start and @End formulas on your Page Header to display the selected parameters.
via: Beth Bowers – Sage MAS 90 and MAS 200 Consultant – Michigan
© 2009, Beth Bowers. All rights reserved. Formed in 2005. the 90 Minds Consulting Group is a collaboration of 100 Sage partners who independently join together online in a 24 x 7 private communication network to solve difficult issues for their customers. The group is not affiliated with Sage and our collaboration provides for unparalleled member access to early warnings of bugs and other issues which members in turn are encouraged to use to provide an exceptional customer experience.
« Jobops for Sage MAS 90 and 200 version 4.3 | Home | New preliminary IRS Payroll Withholding Tax Tables Released »
Leave a Comment
You must be logged in to post a comment.