InScope Function (Reporting Services)

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.
  
  Copy

  =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.
  
  Copy

  =Not(InScope("Product"))
  

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.

InScope("Product")

Concepts

Help and Information