Using 'Where in' in selection formula

[TysonLPrice]

I'm trying to change a 8.5 Crystal report run from VB 6.0 to use multiple columns in a where clause. Current it uses:

rptExceptionsByGroupID;1.RejectionReason} = 'Bwc 100% Emr Cap-Groupable

in a string called strSelectionFormula like this:

.SelectionFormula = strSelectionFormula

I'm trying to change it to:

{rptExceptionsByGroupID;1.RejectionReason} in ( 'Bwc 100% Emr Cap-Groupable' ,'Canceled with BWC' )

The error message shows the string and than the text "The ) is missing"

Can I use the IN clause like that?

 

[Turkbear]

Hi,
Crystal syntax useds squaue brackets for the IN operator, so try:

{rptExceptionsByGroupID;1.RejectionReason} in [ 'Bwc 100% Emr Cap-Groupable' ,'Canceled with BWC' ]

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Turkbear]

Hi,
Obviously I meant SQUARE and USES ( Someday I'll proof better



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[TysonLPrice]

I looked all over trying to find that.
It worked. Thanks!