SQL Solutions for the database developer
Posted by Jeff Rix on May 8, 2012 under SSRS | 
Be the First to Comment
If you have a hierarchy in your Dataset and you would like the records to be displayed in the appropriate order you can handle this in SSIS by specifying a Recursive parent under the Advanced Group Properties for the Row Group.
My Data set has a process id and the process id it is dependent upon.
set the recursive parent for the row group.
The data will now display in the appropriate order.
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.
The font effects are determined by this statement.
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)
