Slightly odd request from a client.
A report shows activities occurring by Area, each area having a fixed set of HomeType options (say A, B, C, D, E), each HomeType having hours, activites and dates recorded against them.
The report asks for a start and end date and then it's just the total hours that are needed for each HomeType, so the Area footer just contains the Hours total and the Details section is set to invisible.
A typical output grouped by Area shows
Area : East
Home Type Total Hours
A 10
D 7
This is all easy enough.
But the client would like to show the full set of HomeTypes for each area, even though many HomeTypes may have no data recorded against them. So the above would need to look like
Area : East
Home Type Total Hours
A 10
B 0
C 0
D 7
E 0
Is there a neat way of doing this?
A report shows activities occurring by Area, each area having a fixed set of HomeType options (say A, B, C, D, E), each HomeType having hours, activites and dates recorded against them.
The report asks for a start and end date and then it's just the total hours that are needed for each HomeType, so the Area footer just contains the Hours total and the Details section is set to invisible.
A typical output grouped by Area shows
Area : East
Home Type Total Hours
A 10
D 7
This is all easy enough.
But the client would like to show the full set of HomeTypes for each area, even though many HomeTypes may have no data recorded against them. So the above would need to look like
Area : East
Home Type Total Hours
A 10
B 0
C 0
D 7
E 0
Is there a neat way of doing this?