Multiple Parameter Fields

[Dominican1979]

Hello Everyone,

Thanks in advance for reading my thread. This is probably simple, but I just can't find my way around it. I have a sales order report that shows item, quantity, price, etc.

When the users run the report, I have a parameter field to enter an order # to be able to pull the detail information about the particular order. This works fine, its pretty straight forward.

Now, I would like to have 3 parameter fields, all 3 would prompt for an order number. They user may enter a value on one of the fields on two or all three and all the details for each order would be combined in one report. Somehow the report needs to know to use whatever value is on each parameter field, and if the field is empty, just use the ones that are filled in.

I hope this makes sense. Im using Crystal XI

 

[lbass]

You need to explain more about the three parameters--why would you have three separate parameters set to the same field? It might help if you provide parameter names and explain the logic for each.

-LB

 

[Dominican1979]

hello lbass,

Sorry for the confusion. Here is what I mean. Currently I have the following parameter: OrdNo

When the users run the report, they are prompted to enter an order number to look up then the report displays the sales records like below:

OrdNo ItemNo Descr Qty Price Total
55656 12345 Metal Glasses 1 59.99 59.99
55656 54631 Plastic Glasses 2 12.00 24.00

This works great, but sometimes they want to combine all items in a report from multiple order numbers up to 3 orders. So this is whawt I want to do. I want to have 3 parameter values OrdNo1, OrdNo2 and OrdNo3. Every time they run the report they will be prompted for 3 parameters, but sometimes they may just wanna pull up one order, or two, or sometimes all three. This is an example below by filling out two of the three parameter values:

OrdNo ItemNo Descr Qty Price Total
55656 12345 Metal Glasses 1 59.99 59.99
55656 54631 Plastic Glasses 2 12.00 24.00
53215 23323 Shoes 1 25.00 25.00
53215 23513 Socks 1 6.00 6.00

So above you can see there are two different order numbers among all the records because in theory the users entered an order number on two of the parameter fields. The third one they left blank, so that one would just be ignored.

I'm not sure if this is possible with parameter fields but basically the users would enter as many order numbers up to 3 as they need it.

I hope this makes a bit more sense. Thanks again for your help

 

[lbass]

You just need one parameter that is set to "allow multiple values".

-LB

 

[Dominican1979]

Hi lbass,

Thanks a lot for your help that works great