2nd group labels showing more than once using drilldowngrouplevel

Posted on 2005-04-19
Medium Priority
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
  • 3
  • 2
LVL 28

Expert Comment

ID: 13818642
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

ID: 13818673
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

bdreed35 earned 1000 total points
ID: 13818748
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

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


Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying 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 …
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…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses
Course of the Month13 days, 8 hours left to enroll

749 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