Solved

How force group total count of 0 to print?

Posted on 2010-09-16
5
436 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

688 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