Cannot Remove Formula from a Report

[Bennie47250]

Still using Crystal 7.0

So I have this report, no telling how old it is, may have been created in Crystal 5 or 6. Using it as a starting point for a new report. There are several formulas this new report does not need so I deleted them from the report layout and now attempting to delete from the listing of formulas. I’m getting the error “Formula field “XXX” is in use. It cannot be deleted". There are 10 formulas like this.

Done the 2 standard things to try to find where they may be in use, changed the variable of the formula from a number to text and exported the report definition to a text file and searched it.

Neither of these things shows me where the formula is in use. Any additional tips on how to remove these would be appreciated.

Thanks
Bennie

 

[hilfy]

Formulas can be used in several places in a report. Here are some additional places to check:

- Select Expert
- Section Expert - if any of the formula buttons for any section are red, click on it to see if the formula is being used there.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[Bennie47250]

Thanks for the suggestions Dell I had checked these and they were all OK.

I have remmed out the contents of the formulas so they aren’t doing anything and using resources I suppose, just want to keep the report "clean" and totally remove them.

Regards
Bennie

 

[hilfy]

Another thing you could do would be to replace the contents of each formula (one at a time) with something that throws an error, such as field/0. When you run the report it should show you every place where the formula is used.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[fisheromacse]

another frequently forgotten place that formulas can hide is as a record sort criteria.

 

[IanWaterman]

Also can be used to link Subreports. This is where I always end up looking last ;-)
Section or Field formatting and Running Total evaluate conditions are also good hiding places.

Best way to find them is change datatype.

Just comment out existing text and add a field which is different type. Hopefully when its is executed it will fail and show you where its being used.

Ian