Report Smith and ADP

• Dec 17, 2001

• #2

gtarrant

Technical User

Jul 29, 2001

43

US

Usually, ReportSmith comes with your installation software for ADP. Depending on which ADP version you have (PCPW, HRiozon, Enterprise V2) a version of ReportSmith should come with it. ReportSmith is a third party software that you can buy off the shelf, but ADP tweaks the product to include (for instance)Effective Dated Rows as in Enterprise V2. But yes, you can still use the off the shelf version (from the the web site srs-inc.com)and extract data from ADP tables...it's just the connection that gets tricky sometimes.

 

Upvote 0 Downvote

• Nov 25, 2002

• #3

bharned

Programmer

Jul 15, 2002

8

US

You can also use sqltalk and use sql commands and spool it to file...

 

Upvote 0 Downvote

• Jul 25, 2003

• #4

acurasrx

Programmer

Jan 22, 2003

2

US

You can use any other SQL tool to get a data from ADP. Its just a matter of establishing a connection to the database. Be sure to have a privilege on reading the tables, etc.

Gary
ADP/Peoplesoft - Developer/Administrator
acurasrx@netzero.net

 

Upvote 0 Downvote

• Nov 25, 2003

• #5

samsci

Programmer

Nov 25, 2003

3

US

ADP delivers ReportSmith 3.11 with their products. Depending on whether you are on Oracle or SQL Server and how your ReportSmith.ini file is setup, you might have to login different ways.

Also, be aware of the effective date logic and translate setup.

Basically, if you do not have ReportSmith either on your workstation or on the Citrix environment, you need to get your IS dept to install it.

 

Upvote 0 Downvote

• Apr 19, 2004

• #6

crystalnewbie

MIS

Mar 10, 2004

53

US

I know this is off-topic but it looks like posters here are familiar with ADP (payroll company) which my question is related to and was hoping someone's created custom reports for their E-time product.

Any ADP E-Time users out there that have created custom crystal reports for it?

TIA

P.S. I'll try my luck in the Crystal forums.

 

Upvote 0 Downvote

• Apr 23, 2004

• #7

gtarrant

Technical User

Jul 29, 2001

43

US

I've created a whole library of reports for eTIME. The joins are not very intuitive, but it can be done. The only problem I have with reporting off an eTIME database in general is the very, very slow performance due to the number of row returned - one employee can have six rows of data per day if they are a time stamp employee.

 

Upvote 0 Downvote

• May 3, 2004

• #8

crystalnewbie

MIS

Mar 10, 2004

53

US

gtarrant,

Do you know if it's possible to create custom report to be viewed in E-time and can only be viewed by the superuser account or any account with the same rights as the superuser?

Thanks.

 

Upvote 0 Downvote

• May 6, 2004

• #9

gtarrant

Technical User

Jul 29, 2001

43

US

Within eTIME you can create hyper-finds, but those turn out to be rather limited. Using ReportSmith, this would be outside the application using an ODBC connection. The user who generates reports with ReportSmith would need the user id and password for the database server, which is outside eTIME's application security. In answer to your question (if I have it right) ReportSmith can not be used WITHIN the eTIME application.

 

Upvote 0 Downvote

• May 21, 2004

• #10

crystalnewbie

MIS

Mar 10, 2004

53

US

gtarrant,

Which reporting tool did you use to create E-time reports? If crystal, did you ever use a stored procedure as a data source?

I would like to use a sql server stored procedure but not quite sure how to tie it to the E-time application.

 

Upvote 0 Downvote

• Jun 29, 2004

• #11

wahby

Programmer

Jun 29, 2004

1

US

How can I establish a connection from sql to eTime?

 

Upvote 0 Downvote