Create a pre-passed aggregate on payroll date and don't select total select
maximum (to get the last date labor was turned in on.) Prepassing this
variable will allow to put it in the filter so you can say all operations
that were completed on this date.
Patrick J. Winter
Information Services Manager
sSc Specialty Screw Corporation
Vantage 4.00.901
-----Original Message-----
From: Todd Anderson [mailto:tanderson@...]
Sent: Sunday, November 19, 2000 04:53 PM
To: 'vantage@egroups.com'
Subject: [Vantage] On what date was an operation completed ?
This is one of those odd trivia questions that I have been unable to crack.
From the Jobhead / Joboper / Labordtl sequence of tables.
I'd like to run a report from Progress Report Writer showing all operations
completed on a specific date for a specific work center showing the labor
detail records.
Such as:
Job-Number, Part-number, Description
---> Oper-seq, work-center, est-setup, act-setup, est-prod, act-prod,
job-qty, completed qty
--->---> clock-in-date, emp, clock-in-time, clock-out-time, lbr-hrs,
bur-hrs, setup/prod, qty-comp, operator-notes
--->---> etc. - show all records
The problem I'm running into is that I can't find a way from Report-Writer
to filter on the date the operation --was-- completed. From what I see I
need the date from the LAST labordtl record but if I filter on that I will
loose any labordtl records from previous days on the same job.
This should be easy ... what am I missing ?
Todd Anderson
J. Rubin & Co.
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
maximum (to get the last date labor was turned in on.) Prepassing this
variable will allow to put it in the filter so you can say all operations
that were completed on this date.
Patrick J. Winter
Information Services Manager
sSc Specialty Screw Corporation
Vantage 4.00.901
-----Original Message-----
From: Todd Anderson [mailto:tanderson@...]
Sent: Sunday, November 19, 2000 04:53 PM
To: 'vantage@egroups.com'
Subject: [Vantage] On what date was an operation completed ?
This is one of those odd trivia questions that I have been unable to crack.
From the Jobhead / Joboper / Labordtl sequence of tables.
I'd like to run a report from Progress Report Writer showing all operations
completed on a specific date for a specific work center showing the labor
detail records.
Such as:
Job-Number, Part-number, Description
---> Oper-seq, work-center, est-setup, act-setup, est-prod, act-prod,
job-qty, completed qty
--->---> clock-in-date, emp, clock-in-time, clock-out-time, lbr-hrs,
bur-hrs, setup/prod, qty-comp, operator-notes
--->---> etc. - show all records
The problem I'm running into is that I can't find a way from Report-Writer
to filter on the date the operation --was-- completed. From what I see I
need the date from the LAST labordtl record but if I filter on that I will
loose any labordtl records from previous days on the same job.
This should be easy ... what am I missing ?
Todd Anderson
J. Rubin & Co.
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)