Skip to Content
avatar image
Former Member

How to show column headers that only appear when the user drills down to see Details

My report has a Group Header, which displays a certain group of fields. And my Details section, which is hidden, contains a different set of fields.

I want to figure out how to display column headers for those fields, which you would only see when you drill down into Details.

Any help would be appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 08, 2017 at 02:45 PM

    Awesome, thanks Abhilash. (I had everything right except the DrillDownGroupLevel=0 part.)

    Also, just a note that you've helped me many times, and I appreciate the help.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 08, 2017 at 07:51 AM

    Hi Jon,

    1. Insert a Group Header 1b section

    2. Insert column headers for the fields on the Details Section in Group Header 1b.

    3. Go to the Section Expert > Highlight Group Header 1b > Click the formula button beside 'Suppress' and use this code:

    DrillDownGroupLevel = 0

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded