Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2011-10-10 : 07:20:27
|
| In my report, there is a bar chart which has three bars. One for each field returned from the database.The report and chart are ok...I would like to find out how to set the max and min values of the y axis.Iin the vertical axis properties, under Axis optioins, there is minimum and maximum section which are set to auto. The present auto settings sometimes shows values greater than the actual values of the bars, so I would like to tell the chart what the min and max values of the y-axis to be.Since there are three fields which are plotted, then how do I find the min and max values to set in the y-axis?I believe I can not just say =min(field1) or max(field1) because field 2 may have a bigger value.What do you think please?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-10 : 07:49:51
|
| take the max of all the three column and put it as max interval and similarly for min------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-10-10 : 08:05:22
|
| Yes, I understand that but not sure how to do this in the report.At present there is a dataset which returns the data for plotting the bar chart.Do you mean I shoul dhave another dataset which find the max and min from that dataset? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-10 : 08:12:57
|
| yep. that would be fine. just add a dataset with single record returning max,min values------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-10-10 : 09:25:52
|
| Solved.Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-10 : 14:37:28
|
| wc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
max and min value of chart y-axis