Error when SQL statement includes a key word

[Andre2]

Hi There

Im using ver 2008.2.273.0 and am finding an error when the report is combiled if I have a "key" word in an sql statement. eg:

Select Date,Amount,Reason from MyTable where RowID= 25 will fail when the report is combiled but

Select Date as TransDate,Amount,Reason from MyTable where RowID= 25 is fine

Cheers

[Edward]

Hello, Andre.

Please select that DataSource in the Designer, then switch to the Property Editor and set AllowExpressions property in false.

Thank you.