Hi i'm kinda new to crystal reports(9.0) so i would greatly appreciate any help.

Im trying to use this simple SQL statement(as an expression field):

SQL Select
    "Currency_Rates"."CR_CODE",
    "Currency_Rates"."CR_DATE",
    "Currency_Rates"."CR_BUY_RATE",
    "Currency_Rates"."CR_SELL_RATE",
    "Currency_Rates"."CR_RSN"
From
    "Currency_Rates"."Currency_Rates"
Where
    "Currency_Rates"."CR_CODE"="Customer"."C_CURRE NCY" and
    "Currency_Rates"."CR_DATE" <= CurrentDate
Order by
    "Currency_Rates"."CR_DATE DESC"


For some reason i get an error stating my syntax is wrong:
"Incorrect syntax near the keyword 'FROM'"

... i've tried changing it around (no quotes,single quotes,etc) numerous times ... but i can't seem to get it right


Hopefully my error is obvious to someone out here :D

THx in advance :D

you cannot use the full sql statements in the SQL expression editor, but only the functions that are available in the function box at the top. You can use a command in CR 9 to get the output of your query in the report.

heh yah thanks i figured it out on my own in the end

so stoopid :D


but thanks for replying :D

I guess I just prefer to see the dark side of things. The glass is always half empty. And cracked. And I just cut my lip on it. And chipped a tooth.