Skip to Content
avatar image
Former Member

How find where is the formula coming from in crystal report

I am working on existing Crystal Reports. When i try to run existing reports i have getting a error like Field not found which the table mentioned in the Formula is not available at present.

But i am not able to find where the formula is coming from, I was not able to find the formula field where it is coming from?

It is just showing its coming from Group #3.

How to find the field where the issue is coming from?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 21, 2017 at 03:01 PM

    Click on the menu item Report, then Group Expert and you should be able to find it. It could be a formatting formula in which case in Design mode right click on the Group section and select Format and have a look in there. If there are any formula the X-2 will be in red

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 21, 2017 at 03:52 PM

    Alternatively when Crystal complains and shows you the offending formula just comment it out by adding

    //

    To the beginning of all lines of code

    Ian

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 21, 2017 at 05:04 PM

    Right-click on any formual and sekect Edit to open Formula Editor

    Click binocular icon in menu to search for the field in all formulas.

    Add comment
    10|10000 characters needed characters exceeded