Solved

How force group total count of 0 to print?

Posted on 2010-09-16
5
433 Views
Last Modified: 2012-05-10
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
Comment
Question by:djnnll
  • 3
  • 2
5 Comments
 
LVL 11

Expert Comment

by:aelliso3
ID: 33694095
Is the report pointing directly to the tables, or to a query, stored proc, etc.?
0
 

Author Comment

by:djnnll
ID: 33694624
The report points directly to the tables.
0
 
LVL 11

Expert Comment

by:aelliso3
ID: 33694949
That makes it much more difficult to do.
         
0
 
LVL 11

Accepted Solution

by:
aelliso3 earned 125 total points
ID: 33694970
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
 

Author Closing Comment

by:djnnll
ID: 33695959
Thanks!
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question