Crystal Reports Display multiple paramter values in Report Header

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design

Topic: Display multiple paramter values in Report Header

Author	Message
tdavenport Groupie Joined: 21 Oct 2008 Location: United States Online Status: Offline Posts: 41	Topic: Display multiple paramter values in Report Header 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.
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	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
	IP Logged

JohnT Groupie Joined: 20 Jan 2008 Online Status: Offline Posts: 92	Posted: 17 Jan 2011 at 9:12am
	You can say "The selected values are " + Join ({?Parameter},",")
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	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
	IP Logged

Yarra Newbie Joined: 13 Dec 2011 Location: United States Online Status: Offline Posts: 10	Posted: 04 Oct 2012 at 5:54am
	John, 'Join' is not working for numeric multi value paramter
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 04 Oct 2012 at 7:10am
	try using totext on the numeric value
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.047 seconds.