djnnll
asked on
How force group total count of 0 to print?
Two subreports are in the main report group footer.
host subreport1 host subreport2
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- --------
AAA 7 AAA 10
BBB 37 BBB 307
CCC 9 DDD 40
DDD 23 -------------------------- ---------- ---------- ---
-------------------------- ---------- ---------- Total Count: 357
Total Count: 76
The host and running total fields are in the subreport's group footers. The total counts are in the subreport's report footers.
How can I make subreport2 display CCC 0? 3 tables are inner joined.
host subreport1 host subreport2
--------------------------
AAA 7 AAA 10
BBB 37 BBB 307
CCC 9 DDD 40
DDD 23 --------------------------
--------------------------
Total Count: 76
The host and running total fields are in the subreport's group footers. The total counts are in the subreport's report footers.
How can I make subreport2 display CCC 0? 3 tables are inner joined.
Is the report pointing directly to the tables, or to a query, stored proc, etc.?
ASKER
The report points directly to the tables.
That makes it much more difficult to do.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!