Description
Returns a number that indicates the hierarchy level of the current group member when you have sorted your group hierarchically.
Arguments
GroupingLevel is a function that determines the level of an existing group. For more information, see
GroupingLevel (fld).
Action
Returns a number that indicates the hierarchy level of the current group member when you have sorted your group hierarchically.
Typical uses
If you want to use a conditional-x-position formula to determine the indentation of individual members in a hierarchical group sort, use this function to track the levels.
Examples
HierarchyLevel (GroupingLevel ({Employee.EmployeeID}))
Returns the level number of each member in your hierarchy assuming that your report is grouped hierarchically on the EmployeeID field.
Comments
This function is evaluated in Pass 2.