I am trying to figure out couple of things on reports that are driving me crazy for past few days. Any pointers would be appreciated:
We are using Telerik.Reporting to display stacked column charts. The data is bound using a stored proc and bound to the chart using declarative properties. The data returned back by sp is fairly simple:
Type Name Total
T1 N1 20
T1 N2 05
T2 N1 03
T2 N3 05
The sp parameters are bound to report parameters and we have a filter on Type (i.e. at a given point of time you are viewing the graph for one type). The graph is on Name and total (Y-axis). Now the issues that we have is:
1. Setting individual bar width dynamically - the number of names that can be returned are dynamic, if only two names are returned the individual bar's width is too much making it look ugly. What we would like to accomplish is setting max-width of a bar somehow.
2. Y-axis scale - If we don't set the scale and the Total returned is a small number, it shows the scale in decimal which doesn't make sense for most of our reports (since they are on Person and other whole numbers). I don't want to hard-code the "MajorStep" of Scale to a number since I still want the scale to be adjusted dynamically based on the "Total" that is being returned, so if the "Totals" are 500, 100 I would rather prefer the MajorStep to be 50. Basically, I want to limit the number of Major ticks and then step the Step based on that, something like say I want to have only 10 major ticks and if the highest total returned is 550, I would want to set my Major step to 550/10 = 55 or somewhere around that.
Let me know if any further information is needed.