SSRS: Auto Current Quarter selections on Filter Parameter
=iif( month(Globals!ExecutionTime)>=5 and month(Globals!ExecutionTime)<=7,1, iif( month(Globals!ExecutionTime)>=8 and month(Globals!ExecutionTime)<=10,2, iif(month(Globals!ExecutionTime)>=2 and month(Globals!ExecutionTime)<=4,4,3 ) ) )
Thanks for the helpful post.. It got me going in the right direction. If I wanted to set up conditional font color based on this parameter in a tablix, how would you write the expression? For example, if quarter=current, "green", "black".
Thanks for the helpful post.. It got me going in the right direction. If I wanted to set up conditional font color based on this parameter in a tablix, how would you write the expression? For example, if quarter=current, "green", "black".
ReplyDelete