Topic: Summarizing grouped data Posted: 12 Jun 2007 at 5:34am
I have a report that has grouped data on it. Below several sets of groups I want to sum up some of those groups into one line. So I want to sum up group C plus group D and group E which will have a header like :
Total of C + D + E
To add to the complexity I want to add the totals of C + D + E which is one number to another group below that say group H. So course an important consideration is into what report bands do these go?
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 12 Jun 2007 at 9:04am
The only way to pull this off is to create formulas and put them in the group footer. The formula has to check what the current group is and add it to the shared variable if it matches the one you want (C, D or E). Then you also need logic which says "If current group = H, then add it to the shared variable C+D+E". It's not that hard, but you are going to have to write a lot of code to cover all these conditions. So you have to be comfortable writing formulas and using shared variables. If not, check out my free chapters online for how all this works (ch 5-7).
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
I have a report that has grouped data on it. Below several sets of groups I want to sum up some of those groups into one line. So I want to sum up group C plus group D and group E which will have a header like :
IP Logged
