I'm working on a calendar report that uses a daily sub-report for each day of the month.
The issue I'm running into is that with auto-scaling, each day scales differently based on the data for that day, meaning that the sub-reports are all displayed using different scales, and so don't lend themselves to side-by-side comparison.
It's impossible to know before run-time what the maximum scale for the entire month will be, so I can't hard set the axis scales either. Is there a way to 'pass in' the required scale to the sub-report along with the other parameters? I tried to put a formula in the CoordinateSystem.YAxis.Scale.Maximum property, but it seems to only accept a hard value and not a formula.