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.
djnnllAsked:
Who is Participating?
 
aelliso3Connect With a Mentor Commented:
Option 1 is to create a table with the values in host that you want and left join the other to it.
Option 2 (and my favorite) is to do this in a stored procedure and start with a temp table.
Option 3 is to create a static list in the report, and populate it with each value that matches your host list
0
 
aelliso3Commented:
Is the report pointing directly to the tables, or to a query, stored proc, etc.?
0
 
djnnllAuthor Commented:
The report points directly to the tables.
0
 
aelliso3Commented:
That makes it much more difficult to do.
         
0
 
djnnllAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.