Crystal Reports Tips and Tricks – Listing Selected Parameters

By Beth Bowers • February 24th, 2009

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.

 

Parameter Sample

via: Beth Bowers – Sage MAS 90 and MAS 200 Consultant – Michigan

  • Share/Bookmark

This website uses IntenseDebate comments, but they are not currently loaded because either your browser doesn't support JavaScript, or they didn't load fast enough.

 

Leave a Comment

You must be logged in to post a comment.

« | Home | »