Solved

Crystal Report Formula issue

Posted on 2011-09-02
5
345 Views
Last Modified: 2012-05-12
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
Comment
Question by:nobile00
  • 2
  • 2
5 Comments
 
LVL 9

Expert Comment

by:jerrypd
ID: 36474930
is that a quote before the From and before the Where?
shouldnt be there!
0
 
LVL 9

Expert Comment

by:jerrypd
ID: 36474933
and is facility a numeric or string?
if numeric, kill those quotes as well
0
 

Author Comment

by:nobile00
ID: 36474961
I removed the quotes around the number and the ' before Where still get the same error.

Facility is in fact  Numeric
0
 
LVL 13

Accepted Solution

by:
LIONKING earned 500 total points
ID: 36475014
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
 

Author Closing Comment

by:nobile00
ID: 36475208
Thanks I used tge Facility = 98 and built a select statement.  Thanks for pointing in the right direction.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question