InScope function to determine the go to report action
Posted by Jeff Rix on October 31, 2011 under SSRS | 
Be the First to Comment
In this report I only wanted to go to a report where the building was expanded to go to a grade.
The font color is determined by this statement.
=IIf(InScope(“GRADE_DESC2″),“BLUE”,“Black”)
The font effects are determined by this statement.
=IIf(InScope(“GRADE_DESC2″),“BLUE”,“Black”)
The action is “go to report”. Instead of specifying a report create an expression using the InScope function
Use Nothing as the false part of this if then statement.
=IIf(InScope(“GRADE_DESC2″),“RiseMarksMarkingPeriodGradeWeek”, NOTHING)
