Report Design: A Better Way To Sum This?

Print Page | Close Window

A Better Way To Sum This?

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=6688
Printed Date: 27 May 2024 at 9:48pm

Topic: A Better Way To Sum This?

Posted By: Azurfire
Subject: A Better Way To Sum This?
Date Posted: 11 Jun 2009 at 3:05pm

I have a report set up basically like this:

Group1
----Group2
--------Data
--------Data
----EndGroup2
----Group2
--------Data
--------Data
----EndGroup2
EndGroup1
<insert another Group1 here>

At then end of each 'Group2', I need to display the sum of all the items in that Group2.
At then end of each 'Group1', I need to display the sum of all the sums calculated at the end of each 'Group2'

Currently, I have just placed a summary field at the end of both Group1 and Group2. However, I'm not sure that this is the best way to do this, because then the Group1 sum is calculated by adding up all the data items again, even though it could just add up the Group2 sums, and I have a LOT of data items.

So is there a better way to set this up?

Thanks.

Print Page | Close Window