Post reply

Format for year to display in grouping(SSRS) report

  • May 1, 2014 at 6:18 am

    #285186

    Hello,

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

  • May 1, 2014 at 7:47 am

    #1710102

    Create a calculated column in your dataset for the year.

    YEAR(SomeDate)

    Then you should be able to group no problem.

  • May 1, 2014 at 8:25 am

    #1710113

    "yyyy" formatting only works with date datatypes

    Far away is close at hand in the images of elsewhere.
    Anon.

  • May 1, 2014 at 9:00 am

    #1710121

    Thank you for the reply, But its not working

    I created a calculated field as Year and assigned FY_1 value field which is coming years from dataset

    Some how not working showing as #Error when I preview the report.

  • May 1, 2014 at 9:30 am

    #1710133

    If FY_1 is a year and assuming it is an int datatype then use the following expression

    =String.Format("Fiscal Year : {0}",Fields!FY_1.Value)

    Far away is close at hand in the images of elsewhere.
    Anon.

  • May 1, 2014 at 10:56 am

    #1710161

    Thank You So much..It got worked.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply