help needed with formula

[rubberhead10]

Hello
I am using crystal reports 11 and have situation that I cant figure out. when we do our payrol check run we take a deduction for our 401k and all of our tax stuff but what has happened is when we run a manual check the deduction for people having a 401k % ammount was missed. the goverment is requiring that we find all of these and correct it but the ammount of datd is enormus. so far I have created a report that has the employee name, check number, check date deduction code and the deduction ammount.
i have set it up to select all the records having deduction code = to 401k% and FED so that it will pull those two record types. what I need is the ability for crystal to show me all the check that an employee that should have a 401k% taken off there check that where missed. as in check# DD00003675 in the following report.....Thanks

SHERI DD00026655 8/3/2007 FED 957.44 42.85
SHERI DD00026655 8/3/2007 401K% 957.44 28.72
SHERI DD00027016 8/17/200 401K% 957.44 28.72
SHERI DD00003675 8/31/200 FED 47.88 0.00
SHERI DD00027370 8/31/200 FED 1,002.32 48.86
SHERI DD00027370 8/31/200 401K% 1,002.32 30.07
SHERI DD00027728 9/14/200 FED 1,101.08 56.78
SHERI DD00027728 9/14/200 401K% 1,101.08 33.03

 

[lbass]

You could insert a group on check and then go to report->selection formula->GROUP and enter:

distinctcount({table.deductioncode},{table.check}) = 1

If it's possible for a check to only have the 401k deduction and not the FED, then change it to:

distinctcount({table.deductioncode},{table.check}) = 1 and
{table.deductioncode} = "401K%"

-LB

 

[rubberhead10]

thanks IT WORKED GREAT