×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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!
  • Students Click Here

*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

Creating a check detail Report

Creating a check detail Report

Creating a check detail Report

(OP)
Hello,

Our company is using PCPW 5.1 and ReportSmith 4.2.

I started to create a CheckDetail report by Paydate, and have created derived fields for each earnings code, deduction code, statutory deds, gross, net and memo codes.  I started with a label template and sized the margins to fit two employees per page.  An example of a derived field is as follows:

 SUM(DISTINCT  DECODE("REPORTS"."V_CHK_VW_EARNINGS"."CHECKVIEWEARNSCD",'B' ,"REPORTS"."V_CHK_VW_EARNINGS"."CHECKVIEWEARNSAMT",NULL ) )

I'm inserting the derived fields into the report, but my question is, more than likely an employee will not have every EC or DC that I've created derived fields for, so is there a way to only display data specific to each employee without having blank information for each category.

I'm thinking that since I'm trying to create a "checkView" type report, the setup can only be done in SQL.

Thank you.

RE: Creating a check detail Report

Quote (Helixe):

more than likely an employee will not have every EC or DC that I've created derived fields for, so is there a way to only display data specific to each employee without having blank information for each category.

You could make each field a macro derived field and check to see if the SQL derived field is NULL or not.  If it is NULL check the next field intel you find some data then display that etc. etc.  That will take an experanced hard core ReportSmith consultant a few days to get it to work correctly.

Could you change the layout of the report so you are using the detail section and just displaying the codes used by the employee?

CharlesCook.com
Specializing in ReportSmith Training and Consulting

RE: Creating a check detail Report

(OP)
Hi Charles,

Thank you for the quick reply.  I figured as much that trying to create a detailed Check report was something only someone like yourself could write. It's almost like trying to recreate ADP's CheckView, but one that you can call based on selection criteria. I've actually had success creating a W2 preview report that I can run at anytime without having to request it from ADP.  This is how I was able to audit W2 information for transfers etc.  In this report I did utilize an employee footer and hid the detail.  I will try my hand at your suggestion of creating a macro derived field, but most likely I'll need some assistance with an example.  I'll try calling my rep at ADP, however, I doubt they'll assist me since they'll consider it a custom and would want to propose a time a cost.  Therefore, if you have the time, maybe you can provide an example of a macro derived field and telling the formula/SQL to check if NULL, if so, then skip to the next field.

Thank you for your time and support.

RE: Creating a check detail Report

Quote:

I'll try calling my rep at ADP, however, I doubt they'll assist me since they'll consider it a custom and would want to propose a time a cost.

There's a good reason they would want to get paid for this.  This is a VERY hard report to create in the format you are looking for.  This is not a report that anyone less then an expert can create.  

You should/need to reconsider the format you are trying to use.  

If you do get a quote from ADP you should shop around.  You can find ReportSmith consultants that are cheaper and more experienced then ADP.

CharlesCook.com
Specializing in ReportSmith Training and Consulting

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