chart y-axis intervals not using formula?

i put the formula day(Parameters!Parameter1.Value) into my y-axis's major gridlines interval value, and it doesn't obey the value i put in.

is this a bug or another "feature"?

when i just type in "31" is works as expected.

is there a work around for this?

I dont think it will accept an Expression. unless you have symbol like fx beside it,you cant enter any expression

neither it is bug nor feature.

Only Constants are accepted here.

others: please correct me if i am not correct

Thanks

|||for Y-axis , no expresions are available. Hence you can't have dynamic Y-axis|||

no, not all fields with out the expression symbol won't accept expressions. the maximum and minimum fields will accept expressions. i guess that's what lead me to expect major gridlines option to accept it.

seems really stupid to not allow it.

as a side note, the dundas control which DOES show the expression field beside major gridlines also doesn't accept any formula, so it must be some internal failing on the part of RS

|||

Hi Tim

The Major Gridlines Interval will accept expressions. I have spent some time working with this to get my charts to display the Y axis scale in consistent way. The key is to derive the maximum value that your chart is going to display dynamically and divide it by the number of gridlines you want displayed.

For example the expression =Ceiling(Max(Fields!Data.Value))/5 will give you five gridlines whose spacing is dependant on the the data selection chosen when the report is run.

In practice I have found that the interaction between Minimun, Maximum and Major Gridlines interval is complex and setting one can have an adverse effect on the other.

As a result I just set one value out of the three depending on what I am trying to achieve.

You can also use expressions containing code if you want to write you own scaling function, which I have found gives the best results.

Hope this helps