Tony
> But there is one type of query that doesn't allow us to use "Use Server
or
> indexes" - a query based on a date data type.
>
> I've reported this to RBTI, but have been told it's because the Crystal
> Reports query engine inserts "garbage" into the query whenever it's based
> on a date. The tech support folks at Crystal Reports deny that and state
> that they pass the same query that is passed for any other data type
except
> to designate it "d" as a date data type.
What version of Crystal are you using?
We are using VB/Oterro 2000 & Crystal 8.5 - our code always sets the SQL
Query expression of the report so we haven't run into this problem.
The SQL produced by Crystal 8.x for its queries does seem to be better that
earlier versions. But I you're already using 8.5........
Best regards
Neil
Neil Smith
Aspen Software
www.aspensoftware.co.uk
