The report is tied to a SQL Server stored procedure with seven parameters. Based on the selections from multiple option groups on the web form i set the parameters and redisplay the chart.  I have overcome the signon and multiple connection issues and am very happy with the performance.

 

I would like to do two things that are escaping me at the moment.

 

1) I would like to dynamically set the minimum and maximum range on the y axis.  Some selections can bring back a range from 10million - 15 million.  Others bring back a range from 600Million - 800million.  Right now all charts are starting at zero even with the "always include zero" unchecked...   I have not found a way to programmically get down to that type of functionality on the chart object

 

2) I would like to show the data labels only on hovering over the point.  Any way to do something like that?

 

Thanks!

 

Thanks,

 

Joe