RB: Time Report by Plant

Yahoo Archive
1
I have used a varying combination of the following tables. Here is my
latest one:

LaborDtl to JobAsm

Company to Company
JobNum to JobNum
JobAsm to JobAsm

Left Outer.

-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Thursday, June 26, 2003 8:24 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB: Time Report by Plant


For performace reasons use LaborDtl.PayRollDate (There is an index
PAYDATE:
Company, PayRollDate)

What do your joins look like? (field by field)


Patrick Winter


-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Thursday, June 26, 2003 8:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RB: Time Report by Plant


I am trying to write a report that shows the time for someone that
clocks
into jobs in a different plant. So far as I can tell the plant
information
is in the JOBHEAD and JOBASM tables. I can't seem to get my joins to
come
out correctly. I am trying to join the LABORDTL and EMPBASIC tables so
my
report could look something like this:

FILTER: EMPBASIC.EMPID - 'DOE01'
JOB?.PLANT = 'PLANT2'
LABORDTL.ACTCLOCKINDATE >= 6/01/03


PLANT2
Clockin ClockOut Total
John Doe 8.00 12.00 4.00

Can anyone provide any clues for me.

TIA,

Juliet



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
2
I am trying to write a report that shows the time for someone that
clocks into jobs in a different plant. So far as I can tell the plant
information is in the JOBHEAD and JOBASM tables. I can't seem to get
my joins to come out correctly. I am trying to join the LABORDTL and
EMPBASIC tables so my report could look something like this:

FILTER: EMPBASIC.EMPID - 'DOE01'
JOB?.PLANT = 'PLANT2'
LABORDTL.ACTCLOCKINDATE >= 6/01/03


PLANT2
Clockin ClockOut Total
John Doe 8.00 12.00 4.00

Can anyone provide any clues for me.

TIA,

Juliet
3
For performace reasons use LaborDtl.PayRollDate (There is an index PAYDATE:
Company, PayRollDate)

What do your joins look like? (field by field)


Patrick Winter


-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Thursday, June 26, 2003 8:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RB: Time Report by Plant


I am trying to write a report that shows the time for someone that clocks
into jobs in a different plant. So far as I can tell the plant information
is in the JOBHEAD and JOBASM tables. I can't seem to get my joins to come
out correctly. I am trying to join the LABORDTL and EMPBASIC tables so my
report could look something like this:

FILTER: EMPBASIC.EMPID - 'DOE01'
JOB?.PLANT = 'PLANT2'
LABORDTL.ACTCLOCKINDATE >= 6/01/03


PLANT2
Clockin ClockOut Total
John Doe 8.00 12.00 4.00

Can anyone provide any clues for me.

TIA,

Juliet



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/