Hi All,
I am new to Crystal and i am struggling how to get such report data pulled.

I have two fields: PayZone(Min,Mid,Max) and PayRate. How can i set payzone as column to give me min, mid and max for the respective emp id. I'm pulling this data from Lawson.
This is what i am referring to...

ID     Min/Hour     Midpt/Hour     Max/Hour
8708     30.41                38.02     45.62
8702     18.02                22.54     27.05
8701     18.02              22.54     27.05
8709     16.40                20.50     24.59
8911     8.50                 8.50     8.50
8946     8.54                 9.82     11.10

Thanks for your help...

dibrani