Crystal Reports and all jobs associated to a Sales Order

I would like to create a report that has a hiarchy of all the jobs
that are associated with a Sales Order. I'm using the JobProd as it
holds the job and assoicated jobs with its parent. We have sub jobs
that go down to 12 levels. Does someone have this report and can it
be done. I would like it done in Crystal 8.5. But I would take it in
any type of report writer. We are running Vantage 6.1.525.

Any help is appreciated.
Joe Sanders
Wipaire, Inc.