Specified or default maximum value for Y-axis in SSRS chart

Question

Hi,

I'm trying to create a report in SSRS with a chart whose Y-axis I want to be able to limit to a user-specified value. It is easy to use a report parameter to do this, but I want to allow a value of null to revert to the auto-calculated maximum. Is there any way to do this?

Answer 1

You could calculate the maximum yourself in as expression. eg.

=IIf(IsNumeric(Parameters!ChartMax.Value),Parameters!ChartMax.Value,Max(Fields!YValue.Value))

You probably want to multiply the max by 1.1 to give you some padding to the top of the graph.