How to select more than one record using two parameters in crystal reports.

See more:

CrystalReports

Hello Code Project people!

I'm a Crystal Reports newbie so please be gentle. :)

I created three parameter string fields.

{?IDNumber1}
{?IDNumber2}
{?IDNumber3}

I want be able to type in three separate ID numbers and have the report select the three records. The report would then print a label for each one. There are dates associated with the labels and I am able to select a range of dates and have them print out like this really easy but that is not what I need. I cannot seem to pick and choose by ID number.

Also... If {?IDNumber2} or {?IDNumber3} is Null it would just skip them and only print out one label.

I basically want it to select {?IDNumber1}, {?IDNumber2}, and {?IDNumber3} but all I ever get when I try this is one label.

Any help would be greatly appreciated!

What I have tried:

I know these do not work but I have tried...

{Assets.IDNumber} in [{?IDNumber1}, {?IDNumber2}, {?IDNumber3}]


{Assets.IDNumber} = [{?IDNumber1}, {?IDNumber2}, {?IDNumber3}]


{Assets.IDNumber} = {?IDNumber1} AND {?IDNumber2} and {?IDNumber3}


{Assets.IDNumber} = {?IDNumber1} OR {?IDNumber2} OR {?IDNumber3}

And tried several options in Selection Expert.