Axis scaling between sub report charts

[tkeen]

Due to the large amount of data I have to chart in a bar graph I have split the data into multiple charts (each one an instance of the same template with different data). The problem that I have is that the individual charts scale the 'Y' axis according to the data on the individual chart. I need to set the charts to all use one common scale based on the overall data without user input. (this is a template that needs to auto refresh and generate reports).

Is there any way to do this? I can pass a "scale value" from the SQL stored procedure easy enough but how can I use this value to scale the charts in the subreports?

Thanks in advance for any help. It is greatly appreciated.

[Ned Pepper]

Don't know which version of crystal you use, but in version 10 and 11 you can select the chart expert, and on the Axes Tab you can set either Auto Range and Auto Scale, or force your own min/max and scale.

[tkeen]

Thanks for the response.

I'm using CR 2008. The problem is that I need to set the values dynamically each time the report is run. Setting it to manual would mean that I would have to set the values in each subreport every time I ran the report. The values need to be updated automatically based on the entire set of data not just that individual sub-reports data.

Tim