[RESOLVED] passing this Recordselectionformula gives me an error

Hi Guys,

I'm passing this to the recordselectionformula:

Code:

---

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

---

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

I'm using Crystal XI and VB6

Try

Code:

---

{Command.ipkcompanyid} IN [462,463]

---

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.:D

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.

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

Oh ok, I found it. Cool