Crystal v8.5 - how do I show all group headers even if there is no data in the details section?

Posted on 2009-04-20
Last Modified: 2012-05-07
please can someone help - I am running a crystal report that just uses one table from Access, and I need to show all the group headers - even if that group is empty? Can anyone help? I am using Crystal v8.5.
many thanks
Question by:dawnyanne
    LVL 18

    Accepted Solution

    Sounds like you might have record selection criteria that is limiting the records that show.  Move the criteria to a conditional suppression formula (from the select expert, check suppress on details and build a formula with the formula builder).  You will likely have to reverse your logic.

    Author Comment

    for this particular group there are no records - but i still want the header to show to indicate this. Do you think there is any way around this? I have looked at a lot of other posts on the site but they are not quite the same as my problem.

    thank you for your help!
    LVL 18

    Expert Comment

    Crystal only shows things for which there are records.  You'll probably need to join another table that includes the other groups.
    LVL 26

    Assisted Solution

    by:Kurt Reinhardt
    UnifiedIS has the right idea.  Traditionally, the way to handle this is to use a "reference" or "lookup" table as your primary table and then join to it. For example, if you have a table with a list of all Sales people and you want to show a group for each sales person, whether or not that person had sales, you would make the Sales Person table the primary table, then left join the actual Sales table to it.  This would allow you to Display headers/footers for each group.  The downside to this approach is that you might negate the left join if you apply any sort of selection criteria to the table on the right.  You can get around this, most of the time, in Crystal, more definitely in SQL.

    Can you go into a little more detail about your report?


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    This video discusses moving either the default database or any database to a new volume.

    759 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

    10 Experts available now in Live!

    Get 1:1 Help Now