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

Question

I am trying to create a report in SSRS with a chart whose Y axis I want to limit to a user-defined value. It's easy to use the report parameter for this, but I want the null value to return to the automatically calculated maximum. Is there any way to do this?

Answer 1

You can calculate the maximum of yourself as an expression. eg.

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

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

Answer 2

Jim, your idea gave me an idea to try, and it worked.

If you simply execute the if statement, except returning an empty value when the parameter is not numeric, SSRS 2005 reverts to default.

So this works:

 =IIf(IsNumeric(Parameters!ChartMax.Value),Parameters!ChartMax.Value,"")