Hello everyone...I am fairly new to Crystal and need some help. I need to pull info from a table as follows:
Basically each employee has several records in this table. But I only need to see employees with the pay code 356 AND any of another set of codes (106, 107, 113, etc.)
So basically I want a crosstab like the following
EMP ID TOTAL HOURS PAYCODE 356 PAYCODE 106 PAYCODE 107 PAYCODE 113
00001 40 15 0 20 0
I have been pulling the original table from Crystal and then using the crosstab in Access because I am comfortable with Access.
Help!
Thanks!
Jen