Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Printed Name of Suppliers Post Reply Post New Topic
Author Message
crist
Newbie
Newbie


Joined: 21 Jun 2010
Location: Singapore
Online Status: Offline
Posts: 29
Quote crist Replybullet Topic: Printed Name of Suppliers
     Posted: 08 Nov 2010 at 8:05pm
Dear Experts,
 
I created a paramater for my list of suppliers which is work fine.
Then, i created a formula for this parameter to show in my report the suppliers i selected.
Below is my supplier formula:
"Supplier(s):  " & minimum ({?Supplier}) & " , " & maximum ({?Supplier})
 
I drag this formula to my report just to show what are the suppliers i selected.
 
BUT, if i selected for than 4 suppliers or more, the printed names of suppliers only show that first and last supplier i selected. The in-between supplier names does not print in my report.
 
Ex: i selected suppliers A, B, C, D
 
It should show as printed as SUPPLIERS: A, B, C, D
 
But it only printed SUPPLIERS: A, D
It doesnt show the B, C supplier name.
 
Can you please help me on this.
 
Thanks in advance.
Crist
 
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 09 Nov 2010 at 3:24am
I have never done this, but it is my understanding/feeling that the {?Supplier} parameter is an array, and so I would attempt to access it using array notation (a for loop with indexing by [index variable])
 
Well, that is what I would try first.  The next idea is to compare all of your vendors to the {?Supplier} parameter and check if they are there by using the 'in' notation (see help for more info).
 
Regardless, you would want to append the 'valid' vendors to a stringvar so that you can print it at some point
 
HTH
IP IP Logged
crist
Newbie
Newbie


Joined: 21 Jun 2010
Location: Singapore
Online Status: Offline
Posts: 29
Quote crist Replybullet Posted: 14 Nov 2010 at 9:08pm
Thanks.
 
I solved this issue, using the "join" command.
Now, all selected suppliers are displayed based on my parameters selection.
 
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.