Solved

How force group total count of 0 to print?

Posted on 2010-09-16
5
417 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
Comment Utility
Is the report pointing directly to the tables, or to a query, stored proc, etc.?
0
 

Author Comment

by:djnnll
Comment Utility
The report points directly to the tables.
0
 
LVL 11

Expert Comment

by:aelliso3
Comment Utility
That makes it much more difficult to do.
         
0
 
LVL 11

Accepted Solution

by:
aelliso3 earned 125 total points
Comment Utility
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
Comment Utility
Thanks!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

743 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now