Error in Formula

Posted on 2006-04-11
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

    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

    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 100

    Expert Comment

    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

    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

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    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…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    733 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

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now