Geek Answers Handbook

Vertical axis in repeating chart values ​​- SQL Reporting Services 2008

Hi, I have the following problem.

I am making a chart in SSRS 2008. I am making a count, and the counting result is 2.

Due to a small calculation, the chart repeats the values ​​on the Y axis. This does not happen, for example, when the number is 50. alt text

How can I get rid of duplicate values ​​1 1 and 2 2. Of course, if I set the interval to 1, the problem is fixed, but if the count is 50, the interval will be displayed from 0 to 50 (0, 1, 2 ... 50, and I do not want it)

Hope someone has an answer, thanks.

+6
charts ssrs-2008
source share
4 answers

You can set the Y axis spacing property to solve the problem. To set an interval property

  • Right click on the y axis.
  • Go to Axis Properties
  • In the axis options you will find the "Interval" under the "scale and grid style" section.
  • Press fx and replace value =IIF( Fields!columnname.Value < 10, 1, 0)

Click OK → OK

That's all.

+5
source share

I made a workaround, I do not think this should be marked as an answer. If anyone has this problem, it can help them.

During the interval I put this fx: = IIF (fields: quotevalues.Value <10, 1, 0)

So if I have an account less than 10, the interval will be 1 by 1. If it is more than 10, the interval will be automatically set.

As I said, if someone has a better solution, it will be welcome.

+2
source share

These are not duplicate values, you need to format the y axis number to include the first decimal place. Once you do this, they should read 1, 1,5, 2, 2,5, etc.

To format numbers on the y axis, right-click on the y axis and go to the Vertical axis. Then select "Number" and increase the decimal number from 0 to 1.

+1
source share

I had the same problem, but I wanted to use a line counter.

This expression in the worked interval: = IIF (CountRows () <10, 1, 0)

0
source share

More articles:


All Articles