Crystal Reports Display multiple parameter values in report

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: Display multiple parameter values in report

Author	Message
brain Newbie Joined: 13 Apr 2010 Online Status: Offline Posts: 36	Topic: Display multiple parameter values in report Posted: 13 Apr 2010 at 6:48am
	Crystal X. How do I display multiple parameter values on the report? When I drag the parameter field to the report, it shows only the first of the user-selected values.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 13 Apr 2010 at 7:15am
	join({?parameter},',')
	IP Logged

brain Newbie Joined: 13 Apr 2010 Online Status: Offline Posts: 36	Posted: 13 Apr 2010 at 7:28am
	Perfect! Thank you.
	IP Logged

Laguna Newbie Joined: 20 Sep 2012 Online Status: Offline Posts: 17	Posted: 20 Sep 2012 at 7:09am
	Hello DBlank! Where do you put this command at? join({?parameter},',') I have the same question about displaying parameters in a report for the report i'm working on and I luckily found this posting. Thanks for your help!
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 20 Sep 2012 at 7:35am
	In the field explorer create a new formula field (right click and select new) drag the formula field onto the report canvas
	IP Logged

Laguna Newbie Joined: 20 Sep 2012 Online Status: Offline Posts: 17	Posted: 20 Sep 2012 at 7:44am
	Excellent! Thank you so much!!
	IP Logged

aeromonte Newbie Joined: 25 Feb 2008 Location: United States Online Status: Offline Posts: 18	Posted: 31 Jul 2013 at 5:02am
	Just came across this. This works for strings, but what about numbers? It doesn't seem to work for a multiple number parameter (example: fiscal period 1, 2, 3)
	IP Logged

aeromonte Newbie Joined: 25 Feb 2008 Location: United States Online Status: Offline Posts: 18	Posted: 31 Jul 2013 at 6:14am
	OK, found this formula that works for multiple numeric parameters - for anyone who needs this in the future: WhilePrintingRecords;Local NumberVar Array InputNum := {?YourParameter}; Local StringVar str := "";Local NumberVar strLen := Count (InputNum);Local NumberVar i; For i := 1 to strLen Step + 1 Do (str := str +', '+ ToText(InputNum ,0,'')); str [3 to Length(str)] Edited by aeromonte - 31 Jul 2013 at 6:15am
	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.016 seconds.