RDA Corp - Business Intelligence and SQL Server

« May 2011 | Main

June 10, 2011

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)

Scale Breaks in SSRS 2008 R2

Ever came across an issue when in your chart some axis values are so high that rest of the chart items almost look like they do not have any values? I recently came across the same issue and thanks to SQL Reporting Services 2008 R2's new Scale Break feature which made my charts look more meaningful.

To enable scale breaks on the chart
1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.

To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.

Note: 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.

Share:  

Posted by Steve Mann at 2:34 PM | Comments (0)