Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 447
  • Last Modified:

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.
0
djnnll
Asked:
djnnll
  • 3
  • 2
1 Solution
 
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
 
aelliso3Commented:
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
 
djnnllAuthor Commented:
Thanks!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now