Report Builder - Dates for Employees

system · September 28, 2001, 11:54am

We use the "Export Utility" and the Employee Master table.
Report Builder won't access that table.

Russ Dover

On 27 Sep 2001, at 10:27, Manasa Reddy wrote:

Hi everyone,

I have a accountant who needs to be able to put in a
date range to see who
was employed. I can see who is active and terminated
from the EmpBasic
table, but I did not see a way to put in a date range.

Anyone else doing something like this? If so, how?

By the way, we are on version 4.904.

Thanks in advance,

Manasa Reddy

Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com

system · September 27, 2001, 11:28am

Hi everyone,

I have a accountant who needs to be able to put in a date range to see who
was employed. I can see who is active and terminated from the EmpBasic
table, but I did not see a way to put in a date range.

Anyone else doing something like this? If so, how?

By the way, we are on version 4.904.

Thanks in advance,

Manasa Reddy

system · September 27, 2001, 11:32am

We do not have the Vantage Payroll module, so we have set-up a VB form on
the Employee that has the Hire Date and Termination Date for each employee.
Using those dates, we can then filter on who was here during a particular
time period. However, I'm not sure if there is any easier way if you have
the payroll module.

system · September 27, 2001, 11:34am

We have the payroll module so I don't have anything set up in VB forms.

So is anyone out there with the module doing anything like this? Is it even
possible?

Thanks,

Manasa Reddy

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Thursday, September 27, 2001 10:41 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder - Dates for Employees

We do not have the Vantage Payroll module, so we have set-up a VB form on
the Employee that has the Hire Date and Termination Date for each employee.
Using those dates, we can then filter on who was here during a particular
time period. However, I'm not sure if there is any easier way if you have
the payroll module.

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/

system · September 27, 2001, 11:58am

Manasa,

The PREmpMas table has hired and fired dates. I'd use this table with the
Export Utility because, if I remember right, this table is encrypted and
will provide useless information if you try to read it in Report Builder.

Using the export utility, you could have an AND filter in there using both
dates and it should give you what you need. For instance, hiredate <=
8/1/01 AND terminationdate >8/31/01 should give you people who were employed
in August. You'd also want to handle the case where terminationdate is
blank (they are still employed there).

Jon Hellebuyck
Stremel Manufacturing

-----Original Message-----
From:
sentto-20369-24255-1001604896-jhellebuyck=stremel.com@...
m
[mailto:sentto-20369-24255-1001604896-jhellebuyck=stremel.com@...
elist.com]On Behalf Of Manasa Reddy
Sent: Thursday, September 27, 2001 10:34 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Report Builder - Dates for Employees

We have the payroll module so I don't have anything set up in VB forms.

So is anyone out there with the module doing anything like this? Is it even
possible?

Thanks,

Manasa Reddy

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Thursday, September 27, 2001 10:41 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder - Dates for Employees

We do not have the Vantage Payroll module, so we have set-up a VB form on
the Employee that has the Hire Date and Termination Date for each employee.
Using those dates, we can then filter on who was here during a particular
time period. However, I'm not sure if there is any easier way if you have
the payroll module.

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/

system · September 27, 2001, 12:00pm

Thanks, Jon! I knew there a place with the info, couldn't remember where!

Manasa Reddy

-----Original Message-----
From: Jon Hellebuyck [mailto:jhellebuyck@...]
Sent: Thursday, September 27, 2001 10:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder - Dates for Employees

Manasa,

The PREmpMas table has hired and fired dates. I'd use this table with the
Export Utility because, if I remember right, this table is encrypted and
will provide useless information if you try to read it in Report Builder.

Using the export utility, you could have an AND filter in there using both
dates and it should give you what you need. For instance, hiredate <=
8/1/01 AND terminationdate >8/31/01 should give you people who were employed
in August. You'd also want to handle the case where terminationdate is
blank (they are still employed there).

Jon Hellebuyck
Stremel Manufacturing

-----Original Message-----
From:
sentto-20369-24255-1001604896-jhellebuyck=stremel.com@...
m
[mailto:sentto-20369-24255-1001604896-jhellebuyck=stremel.com@...
elist.com]On Behalf Of Manasa Reddy
Sent: Thursday, September 27, 2001 10:34 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Report Builder - Dates for Employees

We have the payroll module so I don't have anything set up in VB forms.

So is anyone out there with the module doing anything like this? Is it even
possible?

Thanks,

Manasa Reddy

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Thursday, September 27, 2001 10:41 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder - Dates for Employees

We do not have the Vantage Payroll module, so we have set-up a VB form on
the Employee that has the Hire Date and Termination Date for each employee.
Using those dates, we can then filter on who was here during a particular
time period. However, I'm not sure if there is any easier way if you have
the payroll module.

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/

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/

system · September 27, 2001, 12:03pm

You could use the export utility to send the information to excel and then
do your data sorts there. The person doing the export would have to have
payroll manager access.
Nora Story

> -----Original Message-----
> From: Manasa Reddy [mailto:mreddy@...]
>
> I have a accountant who needs to be able to put in a date range to see who
> was employed. I can see who is active and terminated from the EmpBasic
> table, but I did not see a way to put in a date range.
>
> Anyone else doing something like this? If so, how?
>
> By the way, we are on version 4.904.
>
>

system · September 27, 2001, 1:29pm

for each PREmpMas Where PREmpMas.Company = cur-comp
and (PREmpMas.Terminated = no or
(PREmpMas.TerminatedDate >= 01/01/00 and
PREmpMas.TerminatedDate <= 12/31/00)) no-lock
By PREmpMas.SocSecNum:

Manasa:

Here's the text of my query I use as a starting point for any exports from
the PREmpMas table. I change fields/dates to suit the situation.

Terry L. Williams I.S. Manager Chipsco, Inc. 9936 Liberty St. Ext.
Meadville, PA 16335 p.8143336331 x236 f.8143372548 tlw@...
www.chipsco.com

-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Thursday, September 27, 2001 11:59 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Report Builder - Dates for Employees

Thanks, Jon! I knew there a place with the info, couldn't remember where!

Manasa Reddy

-----Original Message-----
From: Jon Hellebuyck [mailto:jhellebuyck@...]
Sent: Thursday, September 27, 2001 10:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder - Dates for Employees

Manasa,

The PREmpMas table has hired and fired dates. I'd use this table with the
Export Utility because, if I remember right, this table is encrypted and
will provide useless information if you try to read it in Report Builder.

Using the export utility, you could have an AND filter in there using both
dates and it should give you what you need. For instance, hiredate <=
8/1/01 AND terminationdate >8/31/01 should give you people who were employed
in August. You'd also want to handle the case where terminationdate is
blank (they are still employed there).

Jon Hellebuyck
Stremel Manufacturing

-----Original Message-----
From:
sentto-20369-24255-1001604896-jhellebuyck=stremel.com@...
m
[mailto:sentto-20369-24255-1001604896-jhellebuyck=stremel.com@...
elist.com]On Behalf Of Manasa Reddy
Sent: Thursday, September 27, 2001 10:34 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Report Builder - Dates for Employees

We have the payroll module so I don't have anything set up in VB forms.

So is anyone out there with the module doing anything like this? Is it even
possible?

Thanks,

Manasa Reddy

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Thursday, September 27, 2001 10:41 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder - Dates for Employees

We do not have the Vantage Payroll module, so we have set-up a VB form on
the Employee that has the Hire Date and Termination Date for each employee.
Using those dates, we can then filter on who was here during a particular
time period. However, I'm not sure if there is any easier way if you have
the payroll module.

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/

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/