Sunday 20 April 2014

Year Month code starts from November

To get  Year month code column to starts add below query in filter .
[Monthcode Column] > (case when right(?Period?,2) in ('11','12')
 then left(?Period?,4)+'10'
else
cast(left(?Period?,4)-1,varchar(4))+'10'
end)
and
[Month code]<=?Period?

where ?Period? is parameter.