Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Multiple Parameter String Post Reply Post New Topic
Author Message
Debbie Giles
Newbie
Newbie
Avatar

Joined: 16 May 2008
Online Status: Offline
Posts: 10
Quote Debbie Giles Replybullet Topic: Multiple Parameter String
    Posted: 23 Jun 2009 at 6:16am

Hi there

 
I am trying to "string" a Multiple Parameter selections descriptions for my report header. 
 
I can do a Join() for the actual parameter codes, but not for the descriptions. 
 
I can change the parameter value to be the description, but then I lose the code.
 
Is there any way of leaving the parameter as is with the code being the value and the description being the description and then doing a join() on the description.  I even tried a replace() unsuccessfully.
 
I may try concatenate the Codes and descriptions in a formula and use that as my parameter value and not have a description... but I'm not sure I can use a formula for a parameter??
 
Debbie
 

What I have done is, in SQL, I have concatenated the value and description with a - between them and have set up the parameter from that column and not the value and descrition seperately.  Now I can list them unsing the Join() formula. 

My next problem is that my Sales reports have 3000 customers and listing them in cumbersome...  now I have to get thinking about this one.
 
Also is there a way to have a new line instead of a comma between the listed items?
 
DConfused


Edited by Debbie Giles - 23 Jun 2009 at 7:11am
Debbie Giles
Syspro Consultant
EOH
+27 21 525 7200
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 23 Jun 2009 at 1:08pm

if you want a carriage return instead of a comma use:

Join({?My Parameter},chr(13))
 
The x in the "Join(array,x)" is the item that is used to seperate the  fields in the array. chr(13) is the character for a carriage return.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 23 Jun 2009 at 1:09pm
make sure you set your field to can grow or you won't see the new items after each carriage return
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.016 seconds.