Wednesday, December 19, 2018

SSRS - Scale Break features in Chart

In this tutorial, we will learn How to use Scale Break features in your chart report. A scale break is a stripe drawn across the plotting area of a chart to denote a break in continuity between the high and low values on a value axis (usually the vertical, or y-axis). Use a scale break to display two distinct ranges in the same chart area. 


       You cannot specify where to place a scale break on your chart. The chart uses its own calculations based on the values in your dataset to determine whether there is sufficient separation between data ranges to draw a scale break on the value axis (y-axis) at run time.
We will show you a lesser well known feature within SSRS that only takes 1 click to implement. 

We 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.)
To change the style of the scale break
  1. Open the Properties pane.
  2. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object (named Chart Axis by default) are displayed in the Properties pane.
  3. In the Scale section, expand the ScaleBreakStyle property.
  4. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.
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.

No comments:

Post a Comment

Popular Posts

Get Sponsored by Big Brands