I have a file that contains project info. Each project (row) has a unique
name, a unique system ID and an assigned program ID.

Some projects have sub-projects aligned under them and in order to be able
to group these together, the main project and the sub-projects will all be
assigned the same program ID (in order to consolidate them). For example:

PROJECT NAME UNIQUE ID PROGRAM ID DESCRIPTION
Project A 6789 1234 main project
Project B 6790 3456 main project
Project A1 7002 1234 sub project of Project A
Project A2 8000 1234 sub project of Project A
Project C 7000 9990 main project
Project A3 8001 1234 sub project
of Project A
Project B1 8002 3456 sub project
of Project B

I need to report by project name and have all associated sub-projects
(could be a lot) display directly under its main project. (Note: There are
other fields included in reporting such as department, mgr in order to
separate the reports for distribution.)

The common denominator is Program ID which allows the projects to be grouped
by program in order to consolidate financials. Grouping would look
something like this...

PROJECT NAME UNIQUE ID PROGRAM ID DESCRIPTION
Project A 6789 1234 main project
Project A1 7002 1234 sub project of Project A
Project A2 8000 1234 sub project of Project A
Project A3 8001 1234 sub project
of Project A
Project B 6790 3456 main project
Project B1 8002 3456 sub project
of Project B
Project C 7000 9990 main project

However, I have been trying to use pivot reports (with report 6 format) but
I am not able to achieve the proper layout.

Is there any way to get around this? I think I may need the common
denominator to be the project name €“ but not sure how I can do this either.


Any help would be greatly appreciated. Thanks.