I need a report that would list the following:
PROJECT NAME: Desc, Dates, etc.
-----------------------------------
Team Member A1 Team Member B1
Team Member A2 Team Member B2
Team Member A3
------------------------------------
Status: Blah blah
I'm having trouble sorting/grouping this so I can have it come out like this. Right now, Project, Team A, and Team B have their own headers and it repeats (Team A1 - then lists Team B1, B2; Team A2 then Team B1, B2 again).
If I move Team B into Team A header, the whole team does not show. If I move it all into detail, it goes on forever.
I'm half tempted to tell the managers we don't need team B showing ;-) (yeah, that will fly!)
