Axis Object – Auto Interval Error in SSRS line charts

I faced this problem because the data series in my line chart doesn’t have any data when the vertical axis’s minimum, maximum, Interval and Interval type properties are all set to “Auto”.

Reading from the net it seems that this problem can also occur when your data has values of infinity such as when you use an expression to calculate the series data values and there is a division by 0 somewhere which produces infinity.

To solve this problem when there are no data values, I set the minimum value and the maximum value of the vertical axis using the following expression

For minimum value:  =IIf(Min(Fields!Value.Value) = Nothing, 0, “Auto”)

For maximum value: =IIf(Max(Fields!Value.Value) = Nothing, 100, “Auto”)

Basically, if there are no maximum or minimum values in the dataset, set some default values. This way SSRS won’t complain and the report will show with no error messages.

Leave a Reply

Your email address will not be published. Required fields are marked *