Crystal Report Formula issue

I have the following simple formula:
SELECT document_image.ID 'FROM DocM.document_image document_image
'WHERE FACILITY='98'
I keep getting this error and highlights document_image.id this field is a string:
'A number, currency amount, boolean, date, time, date-time, or string is expected here.'

Any help greatly appreciated

nobile00Asked:
Who is Participating?
 
LIONKINGCommented:
If DocM.document_image is already in your table definitions (for the report), then your formula should only be something like:

{DocM.document_image.FACILITY}=98
0
 
jerrypdCommented:
is that a quote before the From and before the Where?
shouldnt be there!
0
 
jerrypdCommented:
and is facility a numeric or string?
if numeric, kill those quotes as well
0
 
nobile00Author Commented:
I removed the quotes around the number and the ' before Where still get the same error.

Facility is in fact  Numeric
0
 
nobile00Author Commented:
Thanks I used tge Facility = 98 and built a select statement.  Thanks for pointing in the right direction.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.