Do a grouping on job number. If you experiment with Dynamic AI design tool then you can see the SQL that it generates to achieve the result. You'll want to make the details in their own level.
-Bob