Link to home
Start Free TrialLog in
Avatar of djnnll
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.
Avatar of aelliso3
aelliso3
Flag of United States of America image

Is the report pointing directly to the tables, or to a query, stored proc, etc.?
Avatar of djnnll
djnnll

ASKER

The report points directly to the tables.
That makes it much more difficult to do.
         
ASKER CERTIFIED SOLUTION
Avatar of aelliso3
aelliso3
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of djnnll

ASKER

Thanks!