Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Summerizing Report Footer Post Reply Post New Topic
Author Message
south
Groupie
Groupie


Joined: 31 Jul 2012
Online Status: Offline
Posts: 82
Quote south Replybullet Topic: Summerizing Report Footer
     Posted: 10 Jun 2013 at 6:47am
I have a report that I want to summerize at the end.  The report list customers and how many deliveries they receive. In the report footer I want to list all the customers that were listed in the report and have the total numbers of delivereis that were made to that customer. 
Example:
Co.       del.
abc      6/1/13
abc      6/2/13
xyz      6/1/13
xyz      6/3/13
xyz      6/4/13
at the end of the report I want it to look like this:
abc         2
xyz         3
For some reason I cannot get it to give me the company names.  I can get it to total deliveries but not list company names?  What am I forgetting to do?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 10 Jun 2013 at 7:33am
use a crosstab
IP IP Logged
south
Groupie
Groupie


Joined: 31 Jul 2012
Online Status: Offline
Posts: 82
Quote south Replybullet Posted: 10 Jun 2013 at 7:57am
Crosstab only list the last customer not all that were on the report.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 10 Jun 2013 at 8:02am

ct expert

row = customer
summarized field=delivery_id set to a count


Edited by DBlank - 10 Jun 2013 at 8:02am
IP IP Logged
south
Groupie
Groupie


Joined: 31 Jul 2012
Online Status: Offline
Posts: 82
Quote south Replybullet Posted: 10 Jun 2013 at 9:52am
??
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 10 Jun 2013 at 9:55am
in the crosstab designer, set the rows in th CT to use the customer field and set the sumamrized field to use a count of your delivery field.
 
If you place the CT in the group footer or page footer it will not work as you epect, it must be in the report footer to look ast all customer names.
IP IP Logged
south
Groupie
Groupie


Joined: 31 Jul 2012
Online Status: Offline
Posts: 82
Quote south Replybullet Posted: 11 Jun 2013 at 10:48am
Thank you!! the CT worked!!
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