locked
Order column by financial Month order RRS feed

  • Question

  • I have created a graph in SSRS

    My X axis shows the month. It uses a text field containing the following examples "April, May, Jun"

    When I deploy the report, the months are out of sync, how do I order the months in financial Year (April - Mar)

    I dont have a date field so i can sort it by that column....

    please help

    Friday, September 4, 2009 1:46 PM

Answers

  • Hi,

    you should go in the Sorting tab of the Category Group Month and or use another field like a numeric field(

    =Fields!MonthNumberOfYear.Value)

    Otherwise you write an expression like that:
    =switch(Fields!MonthName.Value="January",1,Fields!MonthName.Value="February",2,...)

     

    Best Regards

    Antonio

    • Proposed as answer by AntonioCH Friday, September 4, 2009 2:08 PM
    • Marked as answer by SQL_1980 Friday, September 4, 2009 2:59 PM
    Friday, September 4, 2009 2:08 PM
  • In the
    Data -
    Category Group Month - Properties
    Sorting tab -
    Sort on -
    And then you have to select Expression and to write it.


    Hope it solves your problem

    Antonio
    • Proposed as answer by AntonioCH Friday, September 4, 2009 2:43 PM
    • Marked as answer by SQL_1980 Friday, September 4, 2009 2:59 PM
    Friday, September 4, 2009 2:43 PM

All replies

  • Hi,

    you should go in the Sorting tab of the Category Group Month and or use another field like a numeric field(

    =Fields!MonthNumberOfYear.Value)

    Otherwise you write an expression like that:
    =switch(Fields!MonthName.Value="January",1,Fields!MonthName.Value="February",2,...)

     

    Best Regards

    Antonio

    • Proposed as answer by AntonioCH Friday, September 4, 2009 2:08 PM
    • Marked as answer by SQL_1980 Friday, September 4, 2009 2:59 PM
    Friday, September 4, 2009 2:08 PM
  • where do i write the switch function?

    im using Dundas
    Friday, September 4, 2009 2:10 PM
  • In the
    Data -
    Category Group Month - Properties
    Sorting tab -
    Sort on -
    And then you have to select Expression and to write it.


    Hope it solves your problem

    Antonio
    • Proposed as answer by AntonioCH Friday, September 4, 2009 2:43 PM
    • Marked as answer by SQL_1980 Friday, September 4, 2009 2:59 PM
    Friday, September 4, 2009 2:43 PM