force display of detail rows

[ESosnowski]

I need to force the display of detail rows in a report even if values for
these rows are not in the data provided by the query. For example the query
data may be as follows:
Group Detail Qty
1 A 1
1 B 2
2 C 2

I need the report to show:
Group Detail Qty
1 A 1
B 2
C 0
2 A 0
B 0
C 2

Any suggestions?

Thanks

 

[KARL DEWEY]

How is it to know what the maximum value is for the Detail? You are showing
'C' as the max. Is this always the case?

 

[Duane Hookom]

You can probably do this in your report's record source. Create a query with
all possible combinations like:
== qcarGroupDetail =====
SELECT DISTINCT [Group],[Detail]
FROM tblGroups, tblDetails;

Then add this query to your report's record source and join them with a join
type that includes all of the records from qcarGroupDetail.

 

[ESosnowski]

The detail list is always a fixed list. In this example the detail list for
each group section would always be A, B, and C.