Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating a check detail Report 1

Status
Not open for further replies.

Helixe

Technical User
Oct 16, 2006
8
US
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.
 
Helixe said:
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
 
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top