Tony
>
> We're already using Crystal Reports 8.5
>
Given that, I guess you'd have to put a small front end together with VB
and control report data selection that way.
I can see what you mean - I can reproduce it here.
If you use the selection expert and select on a date you end up with some
SQL that looks like:
SELECT
Salesinf.`empid`, Salesinf.`xtransdate`
FROM
`Salesinf` Salesinf
WHERE
Salesinf.`xtransdate` = {d '1996-11-23'}
Crystal does the same sort of thing against a SQL Server 7 datasource,
although SQL Server understands the syntax.
It also happens whether you use OLEDB or ODBC.
Have you officially bugged it through RDCC with a small sample report
against CONCOMP?
To give the RBTI their due, Oterro 1.1 used to put a '1' on the end of all
the correllation names in the SQL Query that Crystal generated and they
fixed that....
Neil
Neil Smith
Aspen Software
www.aspensoftware.co.uk
