At 05:02 PM 5/12/01 -0400, you wrote:
>I'd like to know if anyone else has run into this and if they were able to
>get it to run.
>
>BTW, if you go to the SQL Syntax of Crystal Reports and manually change it
>to conform to R:Base syntax (true SQL) it works.
Crystal 4.5 (a much older version) behaves similarly at my workplace.
Reports with a Crystal Date() function in the Record Selection Formula
return correct results but only after an unindexed search. Entering the
date values directly in the SQL Syntax window results in an indexed search,
with return times more comparable to the same query executed at the R>
prompt. I tried a number of variations in the Record Selection Formula
until I stumbled onto the SQL Syntax alternative, which has become our
method of choice for date-dependent reports from large tables.
We use Crystal here to primarily to support a number of reports created
back when it was the only graphical report writer for RBase, but I sense
not many others on the list are using it (outside of VB/Oterro
applications). If you want to dig further, the technical assistance area
at the Seagate web site may be useful. It may also be helpful to turn on
ODBC logging (in Control Panel) and then inspect the log to compare how the
two queries are being translated through the ODBC layer, although that may
illuminate the problem but not point to a solution.
David B
