Crystal XI
I am putting together a Supervisor listing based off of an employee table.
Each employee has a Supervisor# and Supervisor First and Last Name. I made a formula that concatenated all 3 fields and grouped by that field.
SUPR#+SUPRFN+SUPRLN
Then when I drag the Phone# field into the Group Header it pulls in the phone number of the first person in the group and not the phone number of the supervisor.
I have also tried just creating the group just using Supervisor# and I get the same results.