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

« Jobops for Sage MAS 90 and 200 version 4.3 | Home | New preliminary IRS Payroll Withholding Tax Tables Released »

• 
  
  Need help? Click Here.