force display of detail rows

  • Thread starter Thread starter ESosnowski
  • Start date Start date
E

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
 
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?
 
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.
 
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.
 
Back
Top