Query Calculation Place Holder?

[Captain]

I'm trying to create a crosstab like the above in Report Studio, but have hit a wall in my layout. I'm sorting various account numbers (011, 012, 013, etc) into appropriate groupings by using a Case statement Query Calculation on the Group column. However, I only want to show the Group once I run the report, and not every single account number that falls under it.

The problem here is that how do I deal with account numbers (041) that are not there? Simplistically speaking, each Group (A,B,C,D, etc) should always be show and accounted for, even if there isn't any account numbers that get thrown in there. I'm thinking that there I would need to have some kind of placeholder for Group C, because even though there isn't any account number 041 now, there might be one down the road.

So how do I go about doing this, to get every single Group to show even if there isn't data belonging to it?

Thank you in advanced.

[Lynn]

You could try creating a query that returns all your desired group numbers with a zero value for the metric and then union that together with the "real" query which may or may not have every group. The query items in the query that is the union of the two should have the aggregation method set to sum for the metrics and 'none' for the group and account.