I have an SSRS report where I have a single dataset; I am using parameter as fiscal year.
only one parameter; My requirement was to create a ssrs report with fiscalyear group header.
suppose if I give parameter as 2011 it will display all the years data from 2011 to 2014 and its grouped on fiscal year(group header)
I created an ssrs report with group header my question is why I am facing error at fiscal year(I am not getting fiscal year : 2011) in group header; we have a column as FY_1 where its populating all the years..
I given the expression as -
="Fiscal Year : " + FORMAT(Fields!FY_1.Value,"yyyy")
when I display the report its getting Fiscal Year : yyyy
For the test case I just grouped with system name it working fine; only with fiscal year its not working.
Not sure why its not displaying. Any help..