Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Delete Sum formulas? 2

Status
Not open for further replies.

Bennie47250

Programmer
Nov 8, 2001
515
US
Crystal Reports version 7.0 Access Database

In a report I have created a group and then used the “Insert Grand Total” to total the field for me. Now I’m using that report for a template for a new report that uses different fields (same table). So I delete the sums from the report and the fields, add my new fields and sum them. As I go about updating the formulas, I can still see the original sum formulas. “Group #1 My Table group - A:Sum My Table My Field."

I would like to delete these original formulas but I have been unable to, how can I?

While it is possible these won’t cause a problem, I would like to delete them to keep things clean.

TIA
 
In the design window, right click the group footer or group header and select "delete group". Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
 
If the subtotal isn't on the canvas, and it shows up in the list of fields, that means it is being referenced in a formula somewhere. Change the group to use another field (temporarily) and it will probably cause this formula to error on preview - letting you see where it is used. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
Thanks all. I reviewed my formulas and found that the sum was still referenced. Removed it from the formulas and they went away.

[thumbsup]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top