Dear all,

I have a VB application that call up a Crystal Report, I want to pass a
simple selection formula from VB.

At first I tried to pass a simple formula like {tblTimeRec.UserID}='KK', it
works fine and I can call up Cry Rpt.

Then, in Cry Rpt I tried out another formular, (coz I'm new to Cry Rpt so I
test it in Cry Rpt first):
{tblAccounts.Manager} = 'MP'  And {tblTimeRec.TChgDate} in Date(2002,4,30)
to Date(2002,5,29)

It's work so I build this in VB and replace it with some variables, however,
it gives me a "20515" error.  This is the second time happend on me :(

Is this the issue of my selection formula?  Or since I upgrade the Cry Rpt
from 4.x (shipped with VB) to Cry Rpt 8.5 Pro, will there be any issue
related to this?

Thanks!

K.K.

And... after that I even can't pass the simple Selection formula
{tblTime.UserID} = 'KK', it also gives me 20515 err....

Please help~

K.K.

This is the description of 20515 error:
20515
Error In Formula. There is a formula error in the replacement formula text.
Review the formula syntax and retry.

You must be passing a value in the formula that Crystal doesn't like. Is it
possible that you're passing a value with apostrophe?

Thanks cksj,

Yes, the apostrophe contribute to the problem, I'm now using Chr(34) to
replace it, and interesting enought, I left spaces in my selection formula
editor that causes the trouble too!!

Thanks again~

K.K. :)