JoeDotCom.com

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]“,”")

=iif(inscope(“matrix1_teacherDisplay”),

iif(inscope(“matrix1_courseName”),

IIF(ISNOTHING(Fields!personID.Value), “”, IIF(Fields!personID.Value=0, “”,

ROUND((COUNT(Fields!personID.Value)/Fields!classCount.Value)*100) & “%”

))

,

IIF(ISNOTHING(Fields!personID.Value), “”, IIF(Fields!personID.Value=0, “”,

ROUND((COUNT(Fields!personID.Value)/Fields!courseCount.Value)*100) & “%”

))

)

,

IIF(ISNOTHING(Fields!personID.Value), “”, IIF(Fields!personID.Value=0, “”,

ROUND((COUNT(Fields!personID.Value)/Fields!deptCount.Value)*100) & “%”

))

)

& IIF(0,” <— this entire line begins my comment —>

The lines above and below this sentence cause SSRS to ignore the lines inbetween. The “IIF 0″ constraint guarantees that the IIF statement evaluates false, therefore this text will never be displayed. Below this are are my debugging lines to probe the scope of my matrix report. They will display the code letter for each level of scope they are contained by.

<— this entire line finishes my comment —>”,”")

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

& iif(inscope(“matrix1_courseName”),”[c]“,”")

& iif(inscope(“matrix1_teacherDisplay”),”[t]“,”")

& iif(inscope(“matrix1_periodName”),”[p]“,”")