Export (0) Print
Expand All

InScope Function

SQL Server 2000

InScope Function

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

Syntax
InScope(Scope)
Parameters
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.

Remarks

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.
    =Not(InScope("Product"))
    
Example

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

InScope("Product")
See Also

Other Functions

Show:
© 2014 Microsoft