It is related to the date/datetime function, as I can change the "Date" to
"DateTime" in the following Record Selection Formula Editor and it will
then work....
({Payments.PayInfo} <> "CC Auto" or {Payments.PayInfo}="cash") and
{Payments.Date} > Date (1998, 04, 17)
The "fix" that I just found.. although I have only tested it on one
report... was to FILE, REPORT OPTIONS, Change Convert Date-Time Field "TO
Date-Time" and OK.. and the report then ran....
Ronnie
On Monday, April 27, 1998 3:15 PM, Dale E. Reed Jr.
[SMTP:daler@iea-software.com] wrote:
> Ronnie D. Franklin wrote:
> >
> > I looked through the last thread that discussed Crystal Reports and did
not
> > find my answer, so maybe someone else has the answer!!
> >
> > I installed CR 6.0 and most of the reports work fine, however I have
> > several that come up with "ODBC error"[Microsoft][ODBC SQL Server
> > Driver]Driver not capable" when I try to print or preview it.
>
> I'm not positive, but is this the error you get when the convert
date/time
> to date option is not check?
>
> > This report works fine with CR 4.5...
>
> Are these 4.5 reports that are giving the problem? Is it
> Emerald or Crystal Reports giving this error? If its Emerald,
> what version of Emerald and Crystal Reports PE (crpe32.dll)
> do you have installed?
>
> --
> Dale E. Reed Jr. (daler@iea-software.com)
> _________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com