derived fields 1

[christimess]

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

 

[CharlesCook]

You would need to use Database Grouping to get this down to one line per check. It is more then I could do here. I have a Power point that i presented at MOTM a few years ago that shows how to do this. I could email it to you if you would like.

CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining

 

[christimess]

Thanks. I figured it out. You were right. It was the database grouping. Once I corrected which ones should be checked it worked perfectly.
Thank You for you response. I appreciate it.
Christine