[RESOLVED] Crystal Reports 10.2 - Trying to create a total line???

[blakemckenna]

I have a report that basically prints Project Hours. It's very simple. The records come from a detail file where the Project ID, Date, and Hours Worked are stored. There may be multiple records for the same Project ID, ie;

Project ID Date Hours
XXX123RJ 4/01/2007 5.5
XXX123RJ 4/02/2007 8.0
ZZZ903MM 4/02/2007 3.5
XXX123RJ 4/05/2007 8.0


Report would like this:

Project ID Total Hours
=================================
XXX123RJ 21.5

ZZZ903MM 3.5


I can't seem to get the report to print like this. I know how to insert a Group Section but not sure how to associate a totals/sub-totals field along with the Group.

Thanks,

[blakemckenna]

Anyone have any ideas?

[brucevde]

The formula would simply be

Sum (Field to Sum, Field to Group )

For example - typical Order/Order Details scenario

Sum ({Order_Details.Quantity},{Orders.OrderID} )

Then display the formula in the Group Footer.

Another option. I don't have version 10.2 but would assume it is still the same. Use the Insert -> Summary menu item and fill in the information on that dialog.

[blakemckenna]

Thanks Bruce, I'll give it a try!