Error in Formula

Posted on 2006-04-11
Medium Priority
Last Modified: 2012-05-05
One of my users is using CR 8.0 and has a formula:


When she presses F5 to refresh she gets a msg box stating:

"The remaining text does not appear to be part of the formula"
Question by:stratasoft
LVL 77

Accepted Solution

peter57r earned 1200 total points
ID: 16431712
Hi stratasoft,

It's a long time since I saw these but I think the HFW functions are supplied with a helpdesk system (HEAT?) which includes CR as its reporting tool. (They are not part of standard CR)
There is nothing wrong with the expression you have posted so either there is more to the formula than you have posted or there is some other issue at work.

What  (precisely please)is highlighted when this message appears?

LVL 13

Assisted Solution

EwaldL earned 800 total points
ID: 16440920
If the text HFWDateToDate is highlighted in blue, then the function is known to crsytal repports.
I'd guess though that the text is in black, like any other "random" text you would write (ie "somefunctionnamethatdoesnotexist()" would be in black, "left()" would be in blue since it's know on cr)

if it really is black, then cr doesn't know the function and some external dll will be missing like peter57r indicated.
LVL 101

Expert Comment

ID: 16450520
Agree.  I assume the data is saved with the report thus it works when the report is first run.  You need to find the DLL that has the HFWDateToDate function.  Look for dlls named CRUFLxxxx


Author Comment

ID: 16454067
The user was running Heat from a Citrix Server.  But running Cyrstal Reports from their local computer.  So the Heat Dll's were not on their computer.  I installed Heat on the local PC

Thank fixed it --- Thanks for the info

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
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…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

850 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