none
Multiple Y axis in SSRS reports. RRS feed

  • Question

  •  

    Hi All,

    i am trying to create a report which compares one parameter over two date ranges.Here parameter should be on X axis and date ranges should be present on both sides of Y axis. These type of reports i can create easily in dundas charts but i couldn't find a way to create these reports in SSRS 2008 though Dundas is integrated with the SSRS 2008. Is this feature missed out in the SSRS2008? Please help me in this regard.

    TIA

    Friday, May 30, 2008 8:46 AM

Answers

  •  

    To create reports with multiple y axis, all you need to do.  Select the series you want to graph along that second axis and set it's value axis or category axis to "secondary".

     

    -Sean

    • Marked as answer by Sean Boon Wednesday, July 1, 2009 3:27 PM
    Friday, May 30, 2008 5:04 PM
  • No, it's not possible in SSRS 2005.  If you use a third party control like Dundas (www.dundas.com) you could do it.

    -Sean
    Program Manager, SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/seanboon http://www.twitter.com/ssrs
    • Marked as answer by Sean Boon Wednesday, July 1, 2009 3:27 PM
    Wednesday, July 1, 2009 3:27 PM

All replies

  •  

    To create reports with multiple y axis, all you need to do.  Select the series you want to graph along that second axis and set it's value axis or category axis to "secondary".

     

    -Sean

    • Marked as answer by Sean Boon Wednesday, July 1, 2009 3:27 PM
    Friday, May 30, 2008 5:04 PM
  • Sean,

    Is this thing really possible in SQL Server 2005 ??  I guess not....right ??
    Thanks a bunch ! Sweta
    Wednesday, July 1, 2009 3:07 PM
  • No, it's not possible in SSRS 2005.  If you use a third party control like Dundas (www.dundas.com) you could do it.

    -Sean
    Program Manager, SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/seanboon http://www.twitter.com/ssrs
    • Marked as answer by Sean Boon Wednesday, July 1, 2009 3:27 PM
    Wednesday, July 1, 2009 3:27 PM