[RESOLVED] passing this Recordselectionformula gives me an error

[Nitesh]

Hi Guys,

I'm passing this to the recordselectionformula:

({Command.ipkcompanyid} IN(462,463))

and I get an error saying: The ) is missing. Please help.

I'm using Crystal XI and VB6

[VBFnewcomer]

Try

{Command.ipkcompanyid} IN [462,463]

[Nitesh]

Wow,

Thanks alot VBFnewcomer. It works great. Please explain to me why my method wasn't working. I sat with this for half the day . Thank you so much.

[VBFnewcomer]

nothing great about it. click Report->Select Expert... you should find a small window with two combos open up. Click the left one you should find "is one of " select it. Now the Right combo should list all the values from the db, click one by one (as reqd). Now click on Show Formula... your answer is there. Just a syntax problem. The list needed a [] brackets.

[Nitesh]

I dont get those combo's that you are referring to. Doesn't matter though. Thanks again.

Oh ok, I found it. Cool