Using formula in CR passed from VB 1

[kamilas]

I am working on CR using Visual Studio-VB.
I passed parameter(Integer value) to CR from VB
CrystalReport1.Formulas(0) = "ses = " & Chr(34) & sesId & Chr(34)
and I can see it in CR it is stored at @ses.
Now how can I use to select records where the id is equal to @ses. For example I tried using the SelectRecordExpert:
{TestSession.ID} = {@ses}
It is giving me error 20515 Error in formula.
Please help!

 

[aklein]

I'm guessing that {TestSession.ID} is a number and Crystal doesn't like your testing a number against a string. Try using ToNumber(@ses).

 

[sonper]

kamilas,

You can try this:

On Crystal Report choose Report - Edit Selection Formula - Record then paste the code below then save.

{TestSession.ID} = {@ses}