Solved

How to print Group in Crystal Reports if Group has no details

Posted on 2010-08-30
4
350 Views
Last Modified: 2012-05-10
I have a Crystal Report with a Group #1, a Group #2, and a Details section.  Each section points to a related table.  Group #2 is related to Group #1 through a foreign key in the Group #2 table.  The Details section is related to Group #2 through a foreign key in the Details table.

My problem is that not all of my Group #2 records have entries in the Details table but I want to print all of my Group #2 records.

How do I accomplish this?
0
Comment
Question by:MicheleDunham
[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
  • 2
4 Comments
 
LVL 101

Assisted Solution

by:mlmcc
mlmcc earned 200 total points
ID: 33563308
If the query doesn't return a record for theat group then you really can't provide the header since it doesn't have a record to use.

How do you have the tables joined?
Is there a single recordset for the report or are you using subreports?

mlmcc
0
 
LVL 11

Accepted Solution

by:
tickett earned 300 total points
ID: 33564795
You might be able to get around it by removing the details table from the main report and popping it in a subreport.

L
0
 

Author Comment

by:MicheleDunham
ID: 33570337
Hello,
 
Thank you for the advice on creating a subreport.  I decided to document this solution since it is something others have needed to do and I haven't found anything very explicit out there.

M


CrystalReportParcelDrilldown.doc
0
 

Author Closing Comment

by:MicheleDunham
ID: 33570368
I provided the detailed documentation of my solution so others could benefit.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

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 …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

617 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