Level Function (Reporting Services)
Returns the current level of depth in a recursive hierarchy.
The value returned by the Level function is zero based; that is, the first level in a hierarchy is 0.
The Level function can be used to provide indentation in a recursive hierarchy, such as an employee list. For more information about recursive hierarchies, see Creating Recursive Hierarchy Groups (Reporting Services).
The following code example provides the level of row in the Employees group: