Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Apply sum on grpup summary Post Reply Post New Topic
Author Message
visit2me
Newbie
Newbie
Avatar

Joined: 11 Aug 2010
Location: United States
Online Status: Offline
Posts: 10
Quote visit2me Replybullet Topic: Apply sum on grpup summary
    Posted: 13 Sep 2012 at 6:52am
Hello All,
I am trying to sum each value of group summary.I need to calculate Total side. I have 2 groups, gp1 company, gp2 Date. Please suggest any idea.

---*********--current$$$
Company abc   
7/1/2012   ****   5
7/15/2012 **** 10
8/1/2012   ****   5

company 123
7/1/2012 ****   15
7/15/2012 **** 10
8/1/2012   ****   10

Total
7/1/2012   **** 15
7/15/2012 **** 20
8/1/2012 **** 15

   
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 13 Sep 2012 at 7:31am
you just re-sum the same value at report footer level
IP IP Logged
visit2me
Newbie
Newbie
Avatar

Joined: 11 Aug 2010
Location: United States
Online Status: Offline
Posts: 10
Quote visit2me Replybullet Posted: 13 Sep 2012 at 8:51am
If I just simply re-sum those values from GF2 on report footer then I will get total sum but i wanted to get sum by each Date regardless of company.
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 17 Sep 2012 at 9:48pm
Hi
 

Create a running total for each date. (If your dates are constant for each group)

 

 

Right click on running totals and create new..dt1;

 

--Place the amount field to summarize – and select Summary type—Sum

 

--Evaluate : choose Formula and write a formula like : {datefield} = cdate(year,month,day)

 

--Rest  -- select Never

 

Now place this formula in your report footer

 

 

 

 

Thanks,
Sastry
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 18 Sep 2012 at 3:24am
Sorry, lost track on this. you can go the route Sastry suggested but a different solution that is more dynamic would be to insert a crosstab in the report header or footer, set the row to use the date field grouping on day and then summarize the dollar amount.


Edited by DBlank - 18 Sep 2012 at 3:25am
IP IP Logged
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.033 seconds.