locked
SSRS axis range minimum maximum RRS feed

  • Question

  • User-1098501646 posted

    HI:)

    I try in SSRS to display my chart with the sum of client by date.... 

    i work from a cube where date are like this : 2016-12-01, 2017-01-01 .... in fact the number of client are calculated for every month so every month get for day 1st...   So i want  axis range to display label for only the month of June and December for two last years.... so in axis options i put in minimum that: =cdate(format("2015-06-01", "MMM yyyy"))

    and for maximum that : =cdate(format("2016-12-01", "MMM yyyy")). Besides i choose interval equals to 6 and interval types = months but only january and july display while i want only june and december...

    I don't understand what is wrong. Someone can help me?

    Thank you very much :)

    Vaness ;)

    Tuesday, February 7, 2017 5:09 PM

All replies

  • User-2057865890 posted

    Hi Vaness,

    To change the labels visibility on the axis, we can set the label Interval. You could set interval = 5, June and December and other month would display. In a chart in Reporting Services, we cannot set the visibility of axis labels directly. However, it doesn’t make sense to use field value in the expression for label Interval or Minimum value or Maximum value. 

    reference: https://msdn.microsoft.com/en-us/library/dd239317(v=sql.105).aspx

    Best Regards,

    Chris

    Wednesday, February 8, 2017 8:06 AM
  • User-1098501646 posted

    hI Chris Zhao thank you for your answer.

    In fact i want only to display june and december but with an interval of 6 months but SSRS seems to not understand :(

    An other idea?

    thank you

    Vaness ;)

    Wednesday, February 8, 2017 8:34 AM
  • User-2057865890 posted

    Hi Vaness75,

    An example of a chart specifying different axis intervals is available as a sample report. For more information about downloading this sample report and others, see SQL Server 2008 R2 Report Builder 3.0 and Report Designer sample reports.

    Best Regards,

    Chris

    Friday, February 17, 2017 9:10 AM