RB help

Yahoo Archive
1
Consider it confirmed!

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Friday, October 15, 2004 7:38 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB help


I believe that the LaborDtl.EmployeeNum and the EmpBasic.EmpID are the
same and you can link those two together.

I would confirm that though!
Jasper

-----Original Message-----
From: Mark Howard [mailto:mhoward@...]
Sent: Friday, October 15, 2004 2:01 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RB help




Just a quick one for a Friday afternoon.

I'm writing a report for productivity figures and am using report builder.

I have the labor.dtl table and the job.oper table link and wanted to add
the
emp.basic table so I could pull the employees name through but there
doesn't
seem to be any common links.

The Labor and job table use a employee number but the emp.basic table uses
a
employee ID

Any tip for linking these tables

Regards,

Mark Howard






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
Yahoo! Groups Links









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


Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
2
Happy Thanksgiving All,

I have created a RB report using Laborhed and jcshift to show late clockin
and early leave employee's. However I cannot find a field that holds the
employee name to join correctly. Empbasic is the logical choice, but it just
doesn't seem to work. Any suggestions?

Jim Moore
System Admin.
General Dynamics-OTS (DRI)
256-835-1660 x373
jmoore@...-ots.com
3
That's a tricky one because the EmployeeID is named EmployeeNum in the LaborHed table. You link by company, of course. Then you link LaborHed.EmployeeNum to EmpBasic.EmpID. The names are different, but it's the same field.

Troy Funte
Liberty Electronics
----- Original Message -----
From: Moore, Jim (DRI)
To: 'vantage@yahoogroups.com'
Sent: Wednesday, November 21, 2001 9:40 AM
Subject: [Vantage] RB help


Happy Thanksgiving All,

I have created a RB report using Laborhed and jcshift to show late clockin
and early leave employee's. However I cannot find a field that holds the
employee name to join correctly. Empbasic is the logical choice, but it just
doesn't seem to work. Any suggestions?

Jim Moore
System Admin.
General Dynamics-OTS (DRI)
256-835-1660 x373
jmoore@...-ots.com


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 the Yahoo! Terms of Service.



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

You must join EmpID to EmpNumber. Then you can bring in names from
EmpBasic.

have fun,
john


> -----Original Message-----
> From: Moore, Jim (DRI) [mailto:jmoore@...-ots.com]
> Sent: Wednesday, November 21, 2001 6:41 AM
> To: 'vantage@yahoogroups.com'
> Subject: [Vantage] RB help
5
At 08:40 AM 11/21/2001 -0600, you wrote:
>I have created a RB report using Laborhed and jcshift...
>...I cannot find a field that holds the employee name to join correctly

The field names don't match but the join still works just fine. Here's the
join you need:

LaborHed.Company -> EmpBasic.Company
LaborHed.EmployeeNum -> EmpBasic.EmpID

-Wayne Cox [soon to be leaving the merry position of Network Janitor
@ USAeroteam.com and joining a consulting group to be a proggrammer again,
woo hoo!]
6
That join did the trick. Thanks to all who responded. The 'Onelist',
something else to be thankful for.

Jim

-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Wednesday, November 21, 2001 8:56 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RB help


At 08:40 AM 11/21/2001 -0600, you wrote:
>I have created a RB report using Laborhed and jcshift...
>...I cannot find a field that holds the employee name to join correctly

The field names don't match but the join still works just fine. Here's the
join you need:

LaborHed.Company -> EmpBasic.Company
LaborHed.EmployeeNum -> EmpBasic.EmpID

-Wayne Cox [soon to be leaving the merry position of Network Janitor
@ USAeroteam.com and joining a consulting group to be a proggrammer again,
woo hoo!]




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/
7
Just a quick one for a Friday afternoon.

I'm writing a report for productivity figures and am using report builder.

I have the labor.dtl table and the job.oper table link and wanted to add the
emp.basic table so I could pull the employees name through but there doesn't
seem to be any common links.

The Labor and job table use a employee number but the emp.basic table uses a
employee ID

Any tip for linking these tables

Regards,

Mark Howard
8
I believe that the LaborDtl.EmployeeNum and the EmpBasic.EmpID are the same and you can link those two together.

I would confirm that though!
Jasper

-----Original Message-----
From: Mark Howard [mailto:mhoward@...]
Sent: Friday, October 15, 2004 2:01 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RB help




Just a quick one for a Friday afternoon.

I'm writing a report for productivity figures and am using report builder.

I have the labor.dtl table and the job.oper table link and wanted to add the
emp.basic table so I could pull the employees name through but there doesn't
seem to be any common links.

The Labor and job table use a employee number but the emp.basic table uses a
employee ID

Any tip for linking these tables

Regards,

Mark Howard






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
Yahoo! Groups Links