Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 365
  • Last Modified:

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

0
nobile00
Asked:
nobile00
  • 2
  • 2
1 Solution
 
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
 
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
 
nobile00Author Commented:
Thanks I used tge Facility = 98 and built a select statement.  Thanks for pointing in the right direction.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now