May
18
2010
1

SSRS Expressions: Scope and Commenting Tips

In SSRS, Scope is confusing as hell. Below is an example of adding comments to SSRS expressions and how to probe scope. Adding a line like:

iif(inscope(“matrix1_dept”),”[d]“,”")

will display a “[d]” in cells that are in the scope of group “matrix_dept”, and nothing if it is outside that
scope. By adding multiple scope tests, you can see where cells lie in the scheme of things.
Written by Joe in: Uncategorized | Tags: , , , , , , ,

Powered by WordPress | Aeros Theme | TheBuckmaker.com WordPress Themes