Skip to Content
0
Former Member
Mar 11, 2010 at 08:41 PM

New to Crystal - Crosstab?

24 Views

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