locked
SSRS chart - horozontal axis customization RRS feed

  • Question

  • User-458875980 posted

    Hi,

    Am creating a chart report in SSRS 2008.

    My horozontal axis should be like this. <1hr   <4 hr  <8 hr  <24 hr  <48hr  <96hr  >96hr

    How to customize like this and is thr any expression?

    My data will be in hrs (1,3 ,22 42 etc)

    Please help me on this

     

    by

    Rajesh G

     

     

     

    Friday, December 2, 2011 8:18 AM

All replies

  • User-595703101 posted

    I think you should change your SELECT query for report data and identify with of the horizontal axis values each row will have

    I mean you can add an additional column and set it to <24 if it is 22 hours, etc

    Friday, December 2, 2011 8:40 AM
  • User-1051986203 posted

    Few modification you have to do in sql server query if needed otherwise follow these steps:-

    select the charts->

    go to category groups:->

    category groups properties:->

    lable:->

    click on expression(fx)

    put expression like this over there:-


    =IIF(Fields!hrs.Value="1","<1hr",IIF(Fields!hrs.Value="3","<4hr",IIF(Fields!hrs.Value="22","<24hr",IIF(Fields!hrs.Value="42","<48hr",">96"))))


    click on "ok"

    I hope you will find as you like  caption in horozontal axis.

    Friday, December 2, 2011 8:59 AM