Skip to Content
0
Former Member
May 21, 2014 at 02:46 PM

How can I ensure server-side record selection on DateTime fields?

40 Views

I'm having a problem getting reports to use DateTime fields in record selection formulas. I can see the references in the record selection formula, but when I try to view the resulting SQL, these references seem to be dropped. I need a way to be sure such DateTime field references are passed to the underlying database for performance. The majority of our ~200 reports support record selection based on DateTime fields so this is a big deal for us.

I'm using Crystal Reports IX R2 SP6 and Microsoft SQL Server 2005 (SQL Native Client driver).

Has anyone successfully dealt with this issue?