Last post Feb 17, 2017 09:10 AM by Chris Zhao
Feb 07, 2017 05:09 PM|vaness75|LINK
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 :)
Feb 08, 2017 08:06 AM|Chris Zhao|LINK
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.
Feb 08, 2017 08:34 AM|vaness75|LINK
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?
Feb 17, 2017 09:10 AM|Chris Zhao|LINK
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.