Hello,

I have a table that I am reporting on that goes something like this:

Job    Machine    Sequence     (Calculated Field)
                                           Primary Machine
1234   Machine 1      1            Machine 1
1234   Machine 2      2            Machine 1   
1234   Machine 5      3            Machine 1
1235   Machine 4      1            Machine 4
1235   Machine 7      2            Machine 4
1235   Machine 9      3            Machine 4

All I want to do is group all of the jobs based on the machine that is the first in the sequence(sequence is the order that the job moves from machine to machine). My only idea is to create a formula field to do this.

I feel like this should be something simple. I am very new to Crystal so any help would be appreciated. Also please let me know if any further information is needed.

Thank you

Edited by vanden70 - 30 Aug 2012 at 5:20am

you may be able to do this, but you would have to give me more info.

I am thinking if you grouped by Machine and then sequence (and hid the Machine Group, you could allow order by sequence