Output group headers if no data

[Axoliien]

I am making a report that reports monthly information on our project statuses. There are 4 statuses:

1: Pending
2: Active
3: Completed
4: Maintenance

There are 3 divisions:
1: GIS
2: Web
3: Database

I am making the report to produce the following output, however if there are no records for a given status, the status header does not show up. I have to have at least every status header show up even if nothing is to be output.

Pending:
GIS:
Proj1
Proj2
Web:
Proj3
Proj4

Active:
Gis:
Proj 5
Web:
Proj 6
Database:
Proj 7

Completed:

Maintenance:
Database:
Proj 8

I have made the report and it works fine unless there is nothing to be reported for a specific status (like Completed in the above example). Any suggestions?

Thanks!

 

[glalsop]

Are the status' already stored in their own table?

If so, you can just create a left-outer join between the StatusTable and the current record source for your report, and use the new result set as your report's record source.

If not, then you can create a StatusTable, and do the same.

-Gary