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 wOOdy-Soft 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 only detail that is printed

Status
Not open for further replies.

Mbroad

Programmer
Feb 26, 2004
49
US
I am using Crystal 10 with an Oracle 9 database. I am rather new to Crystal, so bear with me...

I am reading a database of court jurors which are divided into something called panels. I need to SUM the total number of detail records printed at the end of each panel Group. I try using the Insert Summary function within Crystal (SUM the Panel number) and print at the end of each Group, but it prints some high number that is not even close to what I desire. For example, the first Panel had 12 people in it. The Group summary displayed 520!
[pc]
Any help would be appreciated.

thank you.


Government Coder Mark
 
first ... make sure you have a grouping set up for panels. It sonds like you do.
then when you right click on insert ... choose count instead of Sum.

Whatever field you used was apparently a number field and instead of counting ... you just added that field together ...

good luck!
 
Wow! It's that simple!! Thank you very much!
[medal]

Government Coder Mark
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top