×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

New to RS: Duplicates

New to RS: Duplicates

New to RS: Duplicates

(OP)
Our payroll clerk added in the new benefit codes in a table in adp. Now when she runs the bi-weekly benefits report it is coming up with duplicates (well almost) It looks something like this

-------dept---emp---payded---mthlypre---mthlded--emplrshare
Line1---x------x-----x-------------------x----------------
Line2---x------x-----x--------x----------x--------x

Line1: dept, emp, payded, mthlded are present
Line2: dept, emp, payded, mthlypre mthlded, emplrshare

So being new to ReportSmith, I can't figure out how to get rid of the first line and can't figure out why we now have 2 lines for every employee.  Where the data is in both lines, it shows the same amount (which is correct).

We are using SQLBase for ADP on this, ReportSmith 4.2

Kindly

Rick

RE: New to RS: Duplicates

This really could be many things.

Incorrect linking
Poor report design
etc.

It is very hard to tell you how to fix this without seeing the report.

http://CharlesCook.com
Specializing in ReportSmith Training and Consulting

RE: New to RS: Duplicates

(OP)
Mr. Cook

How do I go about getting you the information you need? So that I can attach it and have you look at it?

Kindly

Rick

RE: New to RS: Duplicates

Hi Rick,

I don't have access to PCPW right now so I would need to VPN into your system.

Maby someone else with PCPW can look at it.

http://CharlesCook.com
Specializing in ReportSmith Training and Consulting

RE: New to RS: Duplicates

It's probably because of the way the data is layed out in the view you are choosing.  If you're using the V_Benefits table, a row of data will be returned for each Benefit Type assigned to an employee.  Even if you restrict the benefit types in the selection criteria, it will return as many rows per person as they have.
More than likeley, this is a database grouping issue.  In your example, you would need to "query only" the benefit type, benefit coverage and benefit option.  Then, you would need to create a derived field using either the Max(Distinct) or Sum (Distinct) commands.
Either way, you may want to contact ADP as they could advise you to the specifics for your benefit setup.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close