locked
Chart show 12 month order by key RRS feed

  • Question

  • Hello,

    i have paste a Chart and would like to configure the properties.

    Unfortunely i have no Idea. I would like see 12 Month in the axis and the monthes should be order by the key.

    First January and then February...

    this is my chart:

    THank you


    Kalle

    Wednesday, February 15, 2012 11:03 AM

Answers

  • Right click field which you have mapped in category area -> Category group properties -> Sorting tab -> Add

    Use following expression

    =CDATE("01-" + Fields!MonthName.value + "-2012")

    Order = A to Z

    Regards,

    Asim Bagwan

    Kindly mark the replies as Answers if they help!

    • Proposed as answer by Asim Bagwan Wednesday, February 15, 2012 1:28 PM
    • Marked as answer by Elvis Long Friday, February 24, 2012 9:41 AM
    Wednesday, February 15, 2012 12:14 PM
  • Hi,

    Goto asix properties -> In first tab set interval value to 1 from auto.


    Regards,

    Asim Bagwan

    Kindly mark the replies as Answers if they help!

    • Proposed as answer by Elvis Long Friday, February 17, 2012 9:01 AM
    • Marked as answer by Elvis Long Friday, February 24, 2012 9:41 AM
    Thursday, February 16, 2012 7:01 PM

All replies

  • Hi,

    Right click field which you have mapped in category area -> Category group properties -> Sorting tab -> Add

    Use following expression in case you have monthNumber in your dataset

    =Fields!MonthNumber.value

    Order = A to Z

    else use below expression

    =CDATE("01-" + Fields!MonthName.value + "-2012")

    Order = A to Z


    Regards,

    Asim Bagwan

    Kindly mark the replies as Answers if they help!

    Wednesday, February 15, 2012 11:08 AM
  • if you are developing this report on OLAP database then it is better order the month in the cube rather than in the report and then set the properties interval to be 1.

    Regards,

    Eshwar.

    Wednesday, February 15, 2012 11:26 AM
  • Hello Asim,

    the problem is, that i have no Attribut =Fields!MonthNumber.value, i have just the name of Month but not the Number of the Month.

    Is it anyway possible?

    Thanks


    Kalle

    Wednesday, February 15, 2012 12:11 PM
  • Right click field which you have mapped in category area -> Category group properties -> Sorting tab -> Add

    Use following expression

    =CDATE("01-" + Fields!MonthName.value + "-2012")

    Order = A to Z

    Regards,

    Asim Bagwan

    Kindly mark the replies as Answers if they help!

    • Proposed as answer by Asim Bagwan Wednesday, February 15, 2012 1:28 PM
    • Marked as answer by Elvis Long Friday, February 24, 2012 9:41 AM
    Wednesday, February 15, 2012 12:14 PM
  • thank you very much...

    Kalle

    Wednesday, February 15, 2012 12:48 PM
  • Hello i tried today the same example like yesterday, i have made a new project and i receive this error message if i paste

    =CDATE("01-" + Fields!MonthName.value + "-2012")

    Why???? Conversion from String "01-Januar-2012"

    I use german month, is this the reason maybe ?


    Kalle


    • Edited by KalleSql Thursday, February 16, 2012 3:30 PM
    Thursday, February 16, 2012 3:29 PM
  • Hi,

    Yes. Because of german month. Try to change report language to German.

    Goto report properties -> Language

    Select de


    Regards,

    Asim Bagwan

    Kindly mark the replies as Answers if they help!

    Thursday, February 16, 2012 3:38 PM
  • thank you very much, my last question is ( i hope)

    the chart dont show all monthes, just evers two monthes ... do you know why ??


    Kalle

    Thursday, February 16, 2012 3:55 PM
  • Hi,

    Goto asix properties -> In first tab set interval value to 1 from auto.


    Regards,

    Asim Bagwan

    Kindly mark the replies as Answers if they help!

    • Proposed as answer by Elvis Long Friday, February 17, 2012 9:01 AM
    • Marked as answer by Elvis Long Friday, February 24, 2012 9:41 AM
    Thursday, February 16, 2012 7:01 PM