My Twitter

twitstamp.com
Web Analytics

The InScope() Function and the key to formatting subtotals in SSRS Matrix Objects

What it does
The InScope(<named-scope>) function checks to see if the current item is in the specified scope.
Example – So for the simple matrix report in Fig 1.:

The Green cells fall out-of-scope of the ColumnGroup, and In-Scope for the RowGroup
The Grey cells fall out-of-scope of the RowGroup, and In-Scope for the ColumnGroup
The Light blue [...]