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 sum on existing group summary?

Status
Not open for further replies.

esoxesox

Technical User
Jun 13, 2003
1
US
I've a goofy dataset that has lots of duplicate records in it. I've tried selecting only distinct records and it didn't clear all dups. I know I need to address the dup issues but, in the meantime, need to produce a report summarizing on three group levels. I can't figure out how to insert a summary on an existing group summary (e.g. add all group 2 summaries for a group 1 line summary amount). Any ideas???


Thanks...
 
Right-click on a field and choose Insert to get a choice of Running Total or Summary. A summary at the lowest-level group should have the option to be placed at all levels. Is this what you're after?

It helps to give your Crystal version, since newer versions have extra options, and some extra problems. My workplace is currently upgrading from Crystal 8.5 to Crystal 10, both using databases created by SQL 8.

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top