SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

Level Function (Report Builder 3.0 and SSRS)

SQL Server 2008 R2

Returns the current level of depth in a recursive hierarchy.

NoteNote

You can create and modify report definitions (.rdl) in Report Builder 3.0 and in Report Designer in Business Intelligence Development Studio. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder 3.0 (SSRS) on the Web at microsoft.com.

Copy 

Level(scope)
scope

(String) (Optional). The name of a dataset, group, or data region that contains the report items to which to apply the aggregate function. If scope is not specified, the current scope is used.

Returns an Integer. If scope specifies a dataset or data region, or specifies a nonrecursive grouping (that is, a grouping with no Parent element), Level returns 0. If scope is omitted, it returns the level of the current scope.

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 (Report Builder 3.0 and and SSRS).

The following code example provides the level of row in the Employees group:

Copy 
=Level("Employees")
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.