Crystal Reports error: “The remaining text does not appear to be part of the formula”
“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.
- 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.
- 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. If a Crystal UFL is being used with a file date older than June 22, 2005, then it is highly recommend upgrading to the latest version. If backwards compatibility is required with formulas of previous reports, IDAutomation has the previously released Crystal UFL available.
- 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 Tools\Crystal 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.
- Make sure all patches and updates to Crystal are installed.
- If a runtime version of Crystal Reports is used, make sure all of the runtime DLLs are installed. Please refer to the Crystal Reports Support site for solutions to this issue.
- Try to execute the barcode formula with static data, for example, if using the UFL enter:
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.
- Other issues are documented at the Crystal Reports Support Site.