Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: ? display multiple value parameter in Page Header Post Reply Post New Topic
Author Message
jbalbo
Senior Member
Senior Member
Avatar

Joined: 17 Feb 2011
Online Status: Offline
Posts: 219
Quote jbalbo Replybullet Topic: ? display multiple value parameter in Page Header
    Posted: 29 Mar 2012 at 6:35am
Hi,
 
I have a parameter that allows for multiple values. Can I display all the chosen values in a page header?
 
Thanks
Joe
 


Edited by jbalbo - 29 Mar 2012 at 6:35am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 29 Mar 2012 at 6:44am
you can use the join() function
e.g.
join({?Param},', ')
IP IP Logged
jbalbo
Senior Member
Senior Member
Avatar

Joined: 17 Feb 2011
Online Status: Offline
Posts: 219
Quote jbalbo Replybullet Posted: 29 Mar 2012 at 8:06am
Thank U :)
IP IP Logged
jbalbo
Senior Member
Senior Member
Avatar

Joined: 17 Feb 2011
Online Status: Offline
Posts: 219
Quote jbalbo Replybullet Posted: 29 Mar 2012 at 9:15am
sorry got another ?? on this which would help with other thing also.
What if the paramter was dynamic and you wanted to use the description instead of the value?
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 29 Mar 2012 at 9:17am
you would have to write a loop to convert values to the strings and then join that array.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 29 Mar 2012 at 10:35am
I haven't tried it, but I think you could just add an ToText function.

join(ToText({?Param}),', ')
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 29 Mar 2012 at 10:41am
Nope. since the param allows for multiple values it is an array and you have to subscript it to use the totext. It will appear to work if only one value is selected but breaks as soon as more than one is used.
IP 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.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.