Calculate a group Total

[harding1031]

I have to calculate the total amount of time by group, grouped on a processing line type. The problem is, my boss wants me to display the group totals, just the totals in the beginning of the report. How do I retrieve these group totals prior to running the entire report. I thought about creating a supreport to calculate the group totals that will fire in the report header section, but there has to be a better way to retrieve the totals without a subreport in the report header section.
This is what I have to display:

Group 1 total
Group 2 total
Group 3 total

Group 1
.....details
.....
Group 2
.....details
.....
Group 3
....details
Any ideas. TIA.

 

[synapsevampire]

A conventional summary will work fine for this by right clicking any field in the Details and selecting Insert->Summary->Sum

Or create your own formula such as:

sum({table.field},{table.group})

Since it's a time, you may need to create a formula first to serve as a means to convert the datetime to a time, but that requires example data or at least the data type to understand what needs to be done.

Rather than posting a description, try posting technical info:

Crystal version
Database/connectivity
Example data
Expected output

-k

 

[harding1031]

Crystal 9.0, ODBC
synapsevampire, I can summarize the values just fine in the main report, but how do I display all the summary values of each group at the beginning of the report. See first post, TIA.