Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Parameters Post Reply Post New Topic
Author Message
macke
Newbie
Newbie


Joined: 19 Mar 2009
Location: United Kingdom
Online Status: Offline
Posts: 14
Quote macke Replybullet Topic: Parameters
    Posted: 20 Nov 2009 at 4:28am
Hi I have a that is used to produce works orders and requires the input of a parameter value for the "STOCK_CODE" and a parameter value for the "QUANTITY" required. This works absolutely fine, but I would like to change it to accept multi stock codes and multi values.
 
Say
 
STOCK_CODE    QTY
VCP/1012/MP    400
VCP/1015/MP    336
VCP/1017/MP    440
 
The report would then run and produce a separate page per product.
 
I did try changing the parameter to accept multi values, but I get an error 'The array must be subscripted for example Array
 
Pretty new to this and not sure what to do.
 
Help
 
macke
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 20 Nov 2009 at 7:09am

Likely due to the quantity.

Are you trying to make the quantity relate specifically to one selected stock? Otherwise why would you need multiple quantities?
Pelase expalin what you wan to do with that and then also what your current select statement is.
IP IP Logged
macke
Newbie
Newbie


Joined: 19 Mar 2009
Location: United Kingdom
Online Status: Offline
Posts: 14
Quote macke Replybullet Posted: 25 Nov 2009 at 6:13am

Hi

Yes I need to enter a Stock_Code and the Quantity for that specific Stock_Code.
 
Current single item formula is
 
{STOCK_COMP.ASSEMBLY_CODE} = {?STOCK CODE}
{STOCK_COMP.ASSEMBLY_CODE} = {?STOCK CODE}
 
These are entered currently on an item by item basis. So on stat up a parameter pop up box requests the Stock_Code and the quantity required.
 
mack
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 25 Nov 2009 at 7:29am
Hmmm.
I don't know that you can do this as allowing multiple values because there is no way I know of to make the selection in one param linked only to the selection in the other param.
Depending on how many you want you could just keep adding new params and then writing an OR select statment for that.
 
something like
({STOCK_COMP.ASSEMBLY_CODE} = {?STOCK CODE1} and Quantityfield={?Quantity1}
or
({STOCK_COMP.ASSEMBLY_CODE} = {?STOCK CODE2} and Quantityfield={?Quantity2}
or
({STOCK_COMP.ASSEMBLY_CODE} = {?STOCK CODE3} and Quantityfield={?Quantity3}
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.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.