sql snytax to crystal report.

[homerunkevin]

Morning,
I have a where condition Like "*/*/2003*"

How can this be translated in crystal report? I use in the period form yearto date, between date 2003 01-01- Date 2003 - 12-31. but not data comes out.

I just not sure is the right thing to use or not

Love always,
Kevin Z
Techncial Support specailist

 

[synapsevampire]

That isn't the way to do it in Crystal, and that isn't the way you should do it with real sql either, it isn't very efficient.

Here's an example in Crystal:

Go to the record selection formula (Report->Edit Selection Formula->Record) and place something like:

{table.field) = yeartodate

It will generate the proper SQL for you (check Database->Show SQL Query), and note that it does not use a LIKE predicate as it's slower.

Hope this helps.

-k