Skip to Content
0

How find where is the formula coming from in crystal report

Mar 21, 2017 at 02:42 PM

22

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Don Williams
Mar 21, 2017 at 03:01 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Ian Waterman Mar 21, 2017 at 03:52 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Vitaly Izmaylov
Mar 21, 2017 at 05:04 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded