Crystal Reports Running Total Issue

Report Design

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

Topic: Running Total Issue

Post Reply

Post New Topic

<< Prev Page of 2

Author	Message
Mikeyto_96 Newbie Joined: 26 May 2010 Online Status: Offline Posts: 11	Posted: 15 Jun 2010 at 10:25am
	SUM, correct. 23.51 shows up no matter if I have reset=never or the way it was originally designed.
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 15 Jun 2010 at 10:45am
	Now I am getting confused. What do youw ant to show up and can you tell based on putting the fields in group header 3 what it is including or excluding?
	IP Logged

Mikeyto_96 Newbie Joined: 26 May 2010 Online Status: Offline Posts: 11	Posted: 16 Jun 2010 at 2:30am
	What I need to show up is 23.51 which it is when I move my RT to a different location per your suggestion. But when I keep it in the original location, in the Report Footer and either have reset=never or the original design it sums 11.43 which is only the sum of the very first job.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 16 Jun 2010 at 4:08am
	Can you double check the type of ummary in the RT. What you are describing sounds like it is set to something like maximum or average instead of SUM
	IP Logged

Mikeyto_96 Newbie Joined: 26 May 2010 Online Status: Offline Posts: 11	Posted: 17 Jun 2010 at 1:58am
	The Summary type is SUM. The RT is setup as follows currently. Field to Summarize = JobOper.EstProdHours Evaluate On change of group = Group #3: JobAsmbl.AssemblySeq - A Reset On change of group = Group #1: @GrpByProdGroup - A I have also had Reset=Never and Group #1: JobHead.JobNum - A and Group #3: JobAsmbl.AssemblySeq - A and Group #4: JobOper.OprSeq - A When each has been set they all produce the same result of 11.43 instead of 23.51.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 17 Jun 2010 at 3:53am
	That is not making sense unless the 11.43 is the only value in that field. can you post a little sample row level data and how you have it grouped?
	IP Logged

<< Prev Page of 2

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