Having said that, I have created a report that pulls contribution amounts for employees to their 401K accounts. Within the Oracle database I have to query, there are separate records for each deduction on an employee's check. There are two types of employee contributions, and there is the employer match. The employee contribution has to be either one type or the other.

 

So I created a selection criteria from that table to pull records that are one of the three types:

 

{EMP_DED.DED_NUM} in [399.00, 400.00, 498.00]

 

Doing this, I get two lines per employee detailing their deduction amounts. I need to produce a report (to a CSV export) that has one line per employee, with one column containing their deduction for either type 399.00 or 400.00, and a second column detailing the 498.00 type deduction.

 

I feel the solution is either with grouping or my record selection criteria, but can't find a solution as of yet.