Creating a check detail Report 1

[Helixe]

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.

 

[CharlesCook]

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

 

[Helixe]

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.

 

[CharlesCook]

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