InScope Function (Reporting Services)

Indicates whether the current instance of an item is within the specified scope.




  • Scope
    (String) The name of a dataset, grouping, or data region that contains the report items to which to apply the function.

Return Type

Returns a Boolean.


The InScope function is useful in data regions that have dynamic scoping, such as a matrix. For example, InScope can be used in a drillthrough link in a matrix cell to provide a different report name and different sets of parameters depending on which cell is clicked. An example of this is as follows:

  • This expression, used as the report name in a drillthrough link, opens the ProductDetail report if the clicked cell is in the Month grouping, and the ProductSummary report if it is not.

    =Iif(InScope("Month"), "ProductDetail", "ProductSummary")
  • This expression, used in the Omit property of a drillthrough report parameter, will pass the parameter to the target report only if the clicked cell is in the Product grouping.


Scope cannot be an expression.


The following code example indicates whether the current instance of the item is within the Product dataset, data region, or grouping.


See Also


Creating Expressions in Reporting Services

Help and Information

Getting SQL Server 2005 Assistance