Multiple Values Don't Seem to Work

[Former Member]

I've a report that I've designed where I want to select all of the part numbers that have operations performed on them within a period that I've selected. I've set up parameters for the start and end dates of the period and I've also set up a parameter for the part number selections. I have set the part number parameter up so that multiple values are allowed and so that it also brings up all of the part numbers in the database so the user can select the part numbers that he'd like to be contained in the report. When I run the report, it appears to be displaying the part numbers in the database OK and I can select multiple part numbers. However, when the report runs and does its thing, only the first part number selected is reported, all of the rest of the part numbers in the list are ignored. Crystal says there is only one page for the report. Again, I do have allow multiple values selected for the paramenter. I've also tried this with a new report that basically contains only the prompt for the part number parameter and I'm having the same problem. Can someone help me?

[Former Member · Accepted solution]

Garrett:

Thanks for your response. I guess I don't understand. My parameter name is ?PartNumber. Do I need to create a field in the report and set that equal to the parameter, too? Do I need to include that field in the report somewhere in a selection statement? Thanks for the help.

[Former Member · Accepted solution]

Hi,

Create a parameter give :- allow multivalues= true

Report --> Selection Formulas --> Record

give Fieldname = ?Parameter

Regards

Sathish

[Former Member · Accepted solution]

What the difference between Fieldname = ?Parameter and FieldName in ?Parameter ?

[Former Member · Accepted solution]

Hi,

"IN" is mainly used in situation like

1 . presence of string x in string y.

2. Testing the range values(Date)

3. Array Values.

FieldName = {?Parameter}(with multivalues =true) will work same as FieldName In {?Parameter}

Regards,

Sathish

[Former Member · Accepted solution]

I used "In" in a recent report, and when it worked, I assumed that it was required, and that an equals sign would only choose the first item -- which is definitely not the case, because I just tested it that way.

Sorry for any confusion inflicted.

[Former Member · Accepted solution]

Hi,

I am trying to change it to In {?ParameterList} In crystal, But it does not make the change it puts it back to the = {?ParameterList} condition. Do you know if I need to chage something else.

Thanks.

[Former Member]

Are you using

{Field} = {?ParameterList}

or

{Field} In {?ParameterList}

?