posted 5/22/2012 by ChrisAlbrektson - Views: [1868]
Do you want to make 4 thousand dollars a day? Well, I can’t help you with that but I can show you how to enable scale breaks in your SSRS reports. Below I will show you a lesser well known feature within SSRS that only takes 1 click to implement.
As you can see from my sample report and data below that Devin and Brian have a significantly different number of fans/followers. Even though this is just sample data I’m sure most of you have had a similar experience when designing reports. You have one value that almost reaches the pinnacle of your chart and another that just doesn’t seem to be able to take off, or so the chart says. At first glance it might seem as if the lower value is at or near zero but we can enable scale breaks in order to get a better look at this data.
You can enable this feature by right clicking on the vertical axis and selecting the (Vertical Axis Properties). Then after that just click the check box for (Enable Scale Breaks.)
Once this has been done go back and review your report. As you can see from my example below the lower value is now much easier to see.
When you click on (Enable Scale Breaks) you have a few other options you can change to help customize the report to meet your needs. Below are just 2 that I have had to adjust before.
The 'MaxNumberOfBreaks' I think is self-explanatory. When you click on (Enable Scale Breaks) SSRS will automatically determine how, when and where to place the scale breaks. So if you only want 1 you can change that setting here.
Another property you can change is the ‘CollapsibleSpaceThreshold.’ You can change this setting to help control how aggressive the scale break is. This can be handy if you have a scale break that appears in the report and it probably shouldn’t or maybe it should. You can adjust this up or down to help eliminate this issue.