Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need help with Group Headings and showing them on drill down.

Hi all:

I think this is a simple question and feel that I should already know the answer but for some reason it eludes me. What I would like to know is the proper way to hide/display group headings and have them show up on drill down BUT not repeat on each group header.

What I have for grouping is as follows:

Group Header #1 u2013 Sales Rep

Group Header #2 u2013 Customer

Group Header #3 u2013 Product Class

Group Header #4 u2013 Stock Code

Details

Group Footer #4 u2013 summary calculated on this line

Group Footer #3 u2013 summary calculated on this line

Group Footer #2 u2013 summary calculated on this line

Group Footer #1 u2013 summary calculated on this line

My goal is to have my report show only the lines listed below by default and allow the user to drill down group by group to the details section:

Group Header #1 u2013 Sales Rep

Group Footer #2 u2013 summary calculated on this line

Group Footer #1 u2013 summary calculated on this line

If anyone could offer any help it would be greatly appreciated!

Thanks,

FatMan

replied

click section expert, then for example of GH3, highlight it, then click on the formula box for suppression, and put in the code....

Drilldowngrouplevel < 3

The result will be that this GH3 is suppressed whenever the report is showing GH1 and 2 but not 3.

In addition to this, you must Hide(Drill-down ok) GH3. This is also done in the section expert.

Then just do the same for GF3, and for GH4/GF4 make sure you use...

Drilldowngrouplevel < 4

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question