New User? Sign Up  |  Sign In  |  Help
IDAutomation Logo
Barcode support and
tutorials from IDAutomation
and the community.		 Click for the BBB Business Review of this Computers Hardware, Software & Services in Tampa FL
Resolved Questions

Crystal Reports Formula Error


We keep getting the Crystal Reports error: "The remaining text does not appear to be part of the formula"

Can you give some insight into it?

Operating System: Windows

Application: Crystal Reports

11-11-14     9.9 year(s) ago    

  Report Abuse

 

James

Best Answer

"The remaining text does not appear to be part of the formula" error in Crystal Reports can have several different causes. In every case, the cause is because the formula cannot be processed:

1. If this error occurs on the PC where the report is modified, make sure the formula was entered correctly and with the proper syntax for the version of Crystal Reports running. To solve this issue, refer to the formula examples in IDAutomation's Crystal Reports Barcode Tutorial.

2. This error can occur if a report using a UFL was distributed to a computer that does not have the UFL installed. To solve this issue, install the UFL on all PCs using the report. Problems encountered when distributing Crystal Reports to other PCs are usually associated with the report not being compiled before distribution, or a missing Crystal Report Runtime DLL on the destination PC. It is highly recommend upgrading to the latest version. If backward compatibility is required with formulas of previous reports, IDAutomation has the previously released Crystal UFL available.

3. This error can occur if a report using a formula such as IDAutomation's Barcode Font Formulas for Crystal Reports was distributed to a computer with a version that does not support the source code in the formula. To solve this issue, update Crystal Reports to version 9 or above on all PCs using the report and double-check the compatibility of any modifications made to the code. These formulas are only provided in purchased versions of the barcode font products and appear in the Font ToolsCrystal Reports Formulas folder of the ZIP file. The latest version of IDAutomation's barcode font product is needed in order to obtain these formulas. Download the current version of any IDAutomation product with an active Priority Support & Upgrade Subscription.

4. Make sure all patches and updates to Crystal are installed.

5. If a runtime version of Crystal Reports is used, make sure all of the runtime DLLs are installed. Please refer to Crystal Reports Support for solutions to this issue.

6. Try to execute the barcode formula with static data, for example, if using the UFL enter:

IDAutomationCode128("1234567890", FALSE)

If the static field does not generate an error and formats text to the barcode font, then the UFL and font are working properly and the problem is most likely one of the following listed below.

To obtain support for these issues, contact Crystal Reports Support:
· Required Runtime DLLs are not installed or are corrupted.
· Report was not compiled before distribution.
· User does not have access to retrieve correct data.
· Corrupted report.
· Latest updates to Crystal need to be installed.

Posted 9.9 year(s) ago

(0)
(0)
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.

 Categories
Email this question link to friends
You must enter an email address, if name is entered or vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must starts with "http://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always starts with " http:// ")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 Characters are allowed. Current Count: 0
  Your comment on this answer
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must start with "http://" or "https://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always start with "http://" or "https://")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 characters are allowed. Current Count: 0

You may answer and comment on any thread according to the Terms and Conditions.

 © Copyright 2021 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook