Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Grouping problem Post Reply Post New Topic
<< Prev Page  of 3
Author Message
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 29 Aug 2014 at 9:36am
it has to be on the 'correct' group footer, in this case the footer of the group using the Item field (inner most group).
It has to be set to the correct summary type, in this cas a SUM.
Alsl this process includes suppressed records. If you are doing any row suppression it will still include those records as part of the records to summarize.
IP IP Logged
jjthed
Newbie
Newbie


Joined: 15 Aug 2014
Online Status: Offline
Posts: 20
Quote jjthed Replybullet Posted: 03 Sep 2014 at 5:13am
The group I am using is the 3rd group (most inner group) and I put the qty on the footer of this group. I used the SUM as summery type and there is no suppressed records so it should have all the records.

My crystal report looks like this:

Group 1 (big categories)
Group 2 (small categories)
Group 3 (roll up all the same items and sums up the qty)
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Sep 2014 at 10:13am
unhide the details and verify you have no duplicate values (rows).
A Group Sum will include all rows/values in that group.
IP IP Logged
jjthed
Newbie
Newbie


Joined: 15 Aug 2014
Online Status: Offline
Posts: 20
Quote jjthed Replybullet Posted: 03 Sep 2014 at 11:21am
I don't have anything in my details section. I have duplicate rows, but I need to include all these duplicate values into my sum. The problem I have is that the sum is less than what I expected :(
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Sep 2014 at 11:23am
examples with unhidden details and actual summary values please?
IP IP Logged
jjthed
Newbie
Newbie


Joined: 15 Aug 2014
Online Status: Offline
Posts: 20
Quote jjthed Replybullet Posted: 03 Sep 2014 at 12:53pm
Is there anyway I can upload screen shot or attach a file here?
IP IP Logged
jjthed
Newbie
Newbie


Joined: 15 Aug 2014
Online Status: Offline
Posts: 20
Quote jjthed Replybullet Posted: 04 Sep 2014 at 6:35am
Just an update, I figured out why I got the wrong numbers, somehow, it didn't count the duplicate qty. So I put the item number somewhere on the report and it shows the correct qty now :)
IP IP Logged
<< Prev Page  of 3
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.016 seconds.