Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Total by Group Post Reply Post New Topic
Author Message
mcelwainj
Newbie
Newbie
Avatar

Joined: 18 Oct 2010
Location: United States
Online Status: Offline
Posts: 21
Quote mcelwainj Replybullet Topic: Total by Group
     Posted: 16 Feb 2011 at 5:44am
I have a completed report I made, but I need to add some totals and cannot get it to work.

The report is laid out as follows:

Account Type (residential, Commercial, Industrial)
Account Number| Amount Paid | Address |
Total Accounts:              Total Paid:

I need to add a total field for individual account types. SO I would need a total for Residential, Commercial, Industrial etc....please help!
-Jeremy
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 16 Feb 2011 at 6:28am
do you want this in a group footer or in the report footer or in a header?
IP IP Logged
mcelwainj
Newbie
Newbie
Avatar

Joined: 18 Oct 2010
Location: United States
Online Status: Offline
Posts: 21
Quote mcelwainj Replybullet Posted: 16 Feb 2011 at 7:08am
Preferably in the report footer as a few separate items
-Jeremy
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 16 Feb 2011 at 7:17am
you can make a bunch or running total which is less dynamic and does not account for new types appearing in the report or use a crosstab whcih deals with those problems
for the ct
insert the  ct in the report footer
add the type field in for rows
add the paid field in to the summarized field and set it to a sum
play with the formating to hide lins or totals or whatever to make it visually correct for your report
IP IP Logged
mcelwainj
Newbie
Newbie
Avatar

Joined: 18 Oct 2010
Location: United States
Online Status: Offline
Posts: 21
Quote mcelwainj Replybullet Posted: 16 Feb 2011 at 7:40am
Ah of course, I didn't even think of a ct. Thanks!!!!
-Jeremy
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.