Report Builder Aggregate Field

Yahoo Archive
1
Off hand I would guess you need a sort/group level on the LaborDtl Sequence and accumulate there, resetting at the JobNum level. Otherwise you get only the first (or last?) labor record seen for the job.
-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of ctultra_met
Sent: Monday, April 30, 2007 10:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder Aggregate Field



I am trying to total the scrap pcs. reported in the labor detail in a
Report Builder report. I have an aggregate field totaling the
labordtl.scrapqty, reseting with every job number and accum. with
every job number, final pass. If there are multiple labor entries it
will only pick up the first entry quantity. I cannot get it to total
all entries? I don't think that this scrap qty is recorded anywhere
else either? Would appreciate any help. Thanks.







[Non-text portions of this message have been removed]
2
I am trying to total the scrap pcs. reported in the labor detail in a
Report Builder report. I have an aggregate field totaling the
labordtl.scrapqty, reseting with every job number and accum. with
every job number, final pass. If there are multiple labor entries it
will only pick up the first entry quantity. I cannot get it to total
all entries? I don't think that this scrap qty is recorded anywhere
else either? Would appreciate any help. Thanks.