Crystal Reports Grouping problem

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Grouping problem
	<< Prev Page of 3

Author	Message
DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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 Logged

jjthed Newbie Joined: 15 Aug 2014 Online Status: Offline Posts: 20	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 Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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 Logged

jjthed Newbie Joined: 15 Aug 2014 Online Status: Offline Posts: 20	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 Logged

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

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

jjthed Newbie Joined: 15 Aug 2014 Online Status: Offline Posts: 20	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 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.047 seconds.