Monday, November 26, 2012

SSRS: Auto Current Quarter selections on Filter Parameter

month(Globals!ExecutionTime)>=5 and month(Globals!ExecutionTime)<=7,1,
month(Globals!ExecutionTime)>=8 and month(Globals!ExecutionTime)<=10,2,
iif(month(Globals!ExecutionTime)>=2 and month(Globals!ExecutionTime)<=4,4,3

1 comment:

  1. 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".