Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Supress last group in a dynamically varying group levels

Status
Not open for further replies.

inspi

Technical User
May 24, 2006
50
US

I have a report with 11 groups and each group is a drilldown. This report is to display employee hierarchy structure of an organization. If I go on drilldown on each employee the last level may stop at any group level. For example I am an employee and I have 5 levels above me so for my tree structure I get only 6 levels including me. But the problem is here it is allowing to drilldown even on me and displaying a blank page. The tree structure can stop at different levels for different employees depending on their hierarchy so there is no fixed group at which we can stop the drilldown. Is there any way to avoid getting blank page on last level drilldown for each level (I don't want it to drilldown further when there is nobody under him/her).
This is something urgent.Appreciate your help.
 
I wonder if you could use a section suppression formula that references a combination of two functions, maybe something like:

drilldowngrouplevel > hierarchylevel (groupinglevel({table.employee}))

I didn't test this. Maybe check the help section on these and see whether this might make sense.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top