Print Page | Close Window

Display multiple paramter values in Report Header

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12074
Printed Date: 05 May 2024 at 2:28am


Topic: Display multiple paramter values in Report Header
Posted By: tdavenport
Subject: Display multiple paramter values in Report Header
Date Posted: 14 Jan 2011 at 9:16am

I have a parameter that allows for multiple values. I would like to display all of the selected values in the report header. Currently, it only shows the first parameter that was selected in the list.

How do I show all of the parameter values that were selected in the Report Header?
 
Thank you!


-------------
Any and all suggestions are welcome.


Replies:
Posted By: lockwelle
Date Posted: 17 Jan 2011 at 3:38am
I would create a string variable and iterate though the parameter's array to create a string of all the values selected.
 
Multi value parameters are stored as an array, the array notation is array[index].  I don't remember the loop syntax off-hand, but it can be found in the Crystal Help file.  You will probably need to use Ubound as well to find the number of values selected.
 
HTH

Posted By: JohnT
Date Posted: 17 Jan 2011 at 9:12am
You can say "The selected values are " + Join ({?Parameter},",")

Posted By: lockwelle
Date Posted: 18 Jan 2011 at 3:23am
That's a slick solution.  I don't use the CR parameters screen or arrays that often in CR so I never thought of that, but it is a simple solution.
 
Thanks

Posted By: Yarra
Date Posted: 04 Oct 2012 at 5:54am
John,
'Join' is not working for numeric multi value paramter

Posted By: lockwelle
Date Posted: 04 Oct 2012 at 7:10am
try using totext on the numeric value


Print Page | Close Window