Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: record being counted multiple times Post Reply Post New Topic
Author Message
Imagine!
Newbie
Newbie
Avatar

Joined: 15 Sep 2010
Location: United States
Online Status: Offline
Posts: 4
Quote Imagine! Replybullet Topic: record being counted multiple times
    Posted: 15 Sep 2010 at 11:42am
I have two tables that are linked by JOB.  One contains many detail records per JOB and the other has one record per JOB.  I want to display fields from both tables on one line of the report and total for each JOB.  The fields from the table with one record per JOB are summed based on the number of detail records (if there are 3 detail records the one record field will be 3 times the actual value.)  How do I display the correct value?  I am displaying totals only - no detail, but I allow drill down to the detail.
 
Thank you,
 
Jim
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 15 Sep 2010 at 11:46am
group on JOB
place the fields you want to display on the group footer.
they will only display records from the last row in the group.
for your value create a formula
COUNT(JOB,JOB)*MAXIMUM(numberfield,JOB)
and place in group footer
 
suppress detail section


Edited by DBlank - 15 Sep 2010 at 11:47am
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.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2025 Brian Bischof. All Rights Reserved.