christimess
Programmer
I am trying to create a report that basically shows the break down of an employee's earnings. What we would like is to see one line per employee per check date. So we would like all of the earnings, taxes and deductions to appear on one line. We are using Oracle and we feel that we are getting close to figuring this out, but that we are just not quite there. The derived field that we created is as follows:
DECODE("PS_AL_CHK_DED"."AL_DEDCD",'CHK1',"PS_AL_CHK_DED"."AL_AMOUNT")
By using the above statement we can get the deduction in it's own column, but it is still putting it on it's own line, leaving me with just as many rows as when I began. Does anyone know how I need to modify this statement or what I would need to do to get all the deductions to appear on the same line?
Thanks for your help!
Christine
DECODE("PS_AL_CHK_DED"."AL_DEDCD",'CHK1',"PS_AL_CHK_DED"."AL_AMOUNT")
By using the above statement we can get the deduction in it's own column, but it is still putting it on it's own line, leaving me with just as many rows as when I began. Does anyone know how I need to modify this statement or what I would need to do to get all the deductions to appear on the same line?
Thanks for your help!
Christine