locked
SSRS y-aixs values RRS feed

  • Question

  • I would like to display all values on Y-axis even though SSRS default behaviour is to display only few values on Y-axis based on the size of the chart. Is there any alternate way to display all values on Y-axis irrespective of size of the chart?

     

    here value means name of the person rather than numeric


    RaghuM

    • Edited by MSRN Thursday, November 3, 2011 2:42 PM
    Wednesday, November 2, 2011 10:19 PM

Answers

  • no special approach is required. It will work by changing the Y-axis Intervals.
    RaghuM
    • Marked as answer by MSRN Thursday, November 3, 2011 11:59 PM
    Thursday, November 3, 2011 11:59 PM

All replies

  • Reporting services Y Axis expressions work off numeric values like using minimum,  maximum and intervals. I can think of 2 ways you can do what you are looking for:

    1. Using Strip Lines available in SSRS 2008:

    Axis StripLines in SSRS

    2. Use Person Ids on the Y-Axis as numeric (use for min, max and interval) and then write code in report to pull labels for each id. Something like:

    Get More Out of SQL Server Reporting Services Charts


    http://dailyitsolutions.blogspot.com/
    • Marked as answer by MSRN Thursday, November 3, 2011 4:24 PM
    • Unmarked as answer by MSRN Thursday, November 3, 2011 4:25 PM
    Thursday, November 3, 2011 3:19 PM
  • here even the id contains the characters and we might miss one of the value with min/max interval even if we use this approach.

     



    RaghuM
    Thursday, November 3, 2011 4:24 PM
  • I cant thing/find any other way to doing what you are looking for.

    You may add a type of surrogate column to the table with numeric values and hide it so that end user cant view those values. Then use corresponding text values on SSRS.


    http://dailyitsolutions.blogspot.com/
    • Marked as answer by MSRN Thursday, November 3, 2011 11:28 PM
    • Unmarked as answer by MSRN Thursday, November 3, 2011 11:59 PM
    Thursday, November 3, 2011 9:17 PM
  • no special approach is required. It will work by changing the Y-axis Intervals.
    RaghuM
    • Marked as answer by MSRN Thursday, November 3, 2011 11:59 PM
    Thursday, November 3, 2011 11:59 PM