Crystal Reports Summarize group totals

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: Summarize group totals
	Page of 2 Next >>

Author	Message
stewary Newbie Joined: 18 Dec 2009 Online Status: Offline Posts: 13	Topic: Summarize group totals Posted: 18 Dec 2009 at 6:25am
	How can I summarize group totals to produce grand totals in the report footer?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 18 Dec 2009 at 7:08am
	Depends on how you got the group totals. If they were just straight counts or sums then you just add new counts or Sums without the grouping. If they are more complex you can usually get what you want via a shared variable formula or a Running Total. Edited by DBlank - 18 Dec 2009 at 7:08am
	IP Logged

stewary Newbie Joined: 18 Dec 2009 Online Status: Offline Posts: 13	Posted: 18 Dec 2009 at 7:35am
	Hi and thanks for you quick reply. I got the group total by creating running totals. Can I create a running total directly from a running total? Can you show an example using the shared variable formula? Thanks.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 18 Dec 2009 at 7:47am
	You cannot summarize a summary. However, if you used RTs to get the group level then just create the exact same RT but in the Reset option change it from resetting at the group level to reset at never. There are tons of examples of variables on this site. Lockwelle uses them where I use RTs. Here is a link to one from today http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8670
	IP Logged

stewary Newbie Joined: 18 Dec 2009 Online Status: Offline Posts: 13	Posted: 18 Dec 2009 at 9:29am
	I created the grand totals as you suggested but my totals are too large for what the group totals summed together should be.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 18 Dec 2009 at 9:37am
	Please explain your grouping some row level data and your RT's
	IP Logged

stewary Newbie Joined: 18 Dec 2009 Online Status: Offline Posts: 13	Posted: 18 Dec 2009 at 11:11am
	For the subtotals I have running totals that are reset at the same group level (group level 1), these work fine and I recieve the correct amounts per group. The running totals that I have for the grand totals appear to be out of scope and is selecting all records because it cannot tally the reset amounts obtained in the subtotals. Row level data: ID Job# Activated Revoked 121345 34 True True 121345 19 False True The Activated and Revoked columns are summed if they are true. The group level is based on the ID. Activated: 1 Revoked: 1 Total Activated: 98 Total Revoked: 209
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 18 Dec 2009 at 11:30am
	What about these? Name=TotalActivated Field to summarize= ID Type of Summary=DistinctCount Evaluate= Use a Formula...table.activated=True Reset=Never Name=TotalRevoked Field to summarize= ID Type of Summary=DistinctCount Evaluate= Use a Formula...table.revoked=True Reset=Never
	IP Logged

stewary Newbie Joined: 18 Dec 2009 Online Status: Offline Posts: 13	Posted: 21 Dec 2009 at 3:30am
	It still doesn't provide the correct numbers.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 21 Dec 2009 at 7:08am
	I obviously am not understanding your data. Can you give a little larger sample base and how you want it counted?
	IP Logged

Page of 2 Next >>

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

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

This page was generated in 0.031 seconds.