Machine hours (Vantage 6.1)

Yahoo Archive
1
I have an automated report that distributes a HTML formatted e-mail to each of the department supervisors that shows each machine for there department, what was run on it, by who, from when to when, total hours, pieces produced and percent efficiency. Its written in Progress. Here is the basics of the looping routine that maybe you can use to help get you started with Report Builder or Crystal:

FOR EACH JCDept WHERE JCDept.Company = CUR-COMP NO-LOCK BY JCDept.JCDept:
ASSIGN HrsFound = FALSE.
RUN ZeroTotals.
FOR EACH Machine WHERE Machine.Company = CUR-COMP,
EACH WrkCenter WHERE WrkCenter.Company = Machine.Company
AND WrkCenter.WCCode = Machine.WCCode
AND WrkCenter.JCDept = JCDept.JCDept NO-LOCK:
IF CAN-FIND(FIRST LaborDtl WHERE LaborDtl.Company = Machine.Company AND LaborDtl.PayrollDate = TODAY - 1 AND LaborDtl.LaborType = "P" AND LaborDtl.MachineID = Machine.MachineID NO-LOCK) THEN HrsFound = TRUE.
END.

IF HrsFound THEN DO:
IF NoDataYet = FALSE THEN RUN StartNewMailMessage.
RUN SupervisorEMail.
RUN EMailData("Production for Dept: " + JCDept.JCDept + " (" + STRING(Yesterday) + ")", "Machine Production").
RUN HTML-DailyProduction.
PUT UNFORMATTED "<BR><FONT SIZE=1>".
PUT UNFORMATTED "</BODY></HTML>" SKIP.
END.
END.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Moore, Jim (Anniston)
Sent: Thursday, February 21, 2008 4:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Machine hours (Vantage 6.1)



I'm trying to create a report (RB or Crystal) that will show per day how
many hours each of our shop floor machines were in use.

Does anyone have a report like this they would like to share or maybe
someone can provide some insight into where I would need to start to
create my own.

Thanks,

Jim Moore


----------------------------------------------------------
------------------------------
"This email message is for the sole use of the intended
recipient(s) and may contain proprietary and/or confidential
information for which such intended recipients(s) may have
an obligation to treat as proprietary. Any unauthorized review,
use, disclosure, or distribution is strictly prohibited. If you are
not the intended recipient, please contact sender by reply
email and destroy all copies of this e-mail."
----------------------------------------------------------
-----

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
2
I'm trying to create a report (RB or Crystal) that will show per day how
many hours each of our shop floor machines were in use.

Does anyone have a report like this they would like to share or maybe
someone can provide some insight into where I would need to start to
create my own.

Thanks,

Jim Moore


------------------------------------------------------------------------
------------------------------
"This email message is for the sole use of the intended
recipient(s) and may contain proprietary and/or confidential
information for which such intended recipients(s) may have
an obligation to treat as proprietary. Any unauthorized review,
use, disclosure, or distribution is strictly prohibited. If you are
not the intended recipient, please contact sender by reply
email and destroy all copies of this e-mail."
------------------------------------------------------------------------
-----




[Non-text portions of this message have been removed]