2nd group labels showing more than once using drilldowngrouplevel

Posted on 2005-04-19
Last Modified: 2010-08-05
My second grouping has 2 sections. Section A has doctors names, section B is suppose to hae the detail about the doctors patients. This is the example of the report now:

>>GH2 - doc name
>>>GH2-b patient labels: Patient name | Age | Date of visit

Group 1 has group 2 in it, suppressed until group 1 is selected.
I have the drilldowngrouplevel = 0 code in Section Expert > Suppress [no-drill down] > x-2 for group header #2b.

The check box isnt clicked and the code is there. Is the reason for the drill down code above not working because the level is not 0 anymore?
Question by:joeandem7400
    LVL 28

    Expert Comment

    Based upon the info provided, it sounds like you just need to remove the suppression on GH2b and set the Hide (drill down ok) on all gh2 sections.

    If it is more complicated than that, then provide more info such as:

    Inital view: Just GH1
    Drill into GH1, just show GH2a
    Drill into GH2a, then show GH2b and details

    Author Comment

    This is what i want (as you stated):

    1. Inital view: Just GH1
    2. Drill into GH1, just show GH2a
    3. Drill into GH2a, then show GH2b and details

    your suggestion above didnt work :(
    LVL 28

    Accepted Solution

    Here is what you need to do:

    Report menu, Section Expert.
    Highlight GH1.  GH1 should not be suppressed or hidden.
    Highlight GH2 (not a or b).  Set the Hide (Drill Down OK) property for this section.
    Highlight GH2b.  Click the X+2 button to the right of Suppress (No Drill Down) and add this line:  drilldowngrouplevel < 2
    Highlight Details. Set the Hide (Drill Down OK) property for this section.
    Highlight GF2. Set the Hide (Drill Down OK) property for this section.

    Click OK and Test

    Author Comment

    I love you and this website. Thanks! I have another easy 250 points for you on another question located here:

    Author Comment


    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.

    Join & Write a Comment

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    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 …
    This video discusses moving either the default database or any database to a new volume.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    729 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

    15 Experts available now in Live!

    Get 1:1 Help Now