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
Download the current version of any IDAutomation product with
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. Some of the runtime DLLs required
on the destination PC are listed in
- 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; these include: