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.
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.