How can I get a data label to be positioned at the bottom(base) of a column (vertical bar) graph? I have tried the custom attributes with and without smart labels. The "bottom" value for "LabelStyle" only places the label just below the data marker.

Can you tell me what are your categories, series and data values so that I can try to find a workaround for you?Cheers, Jason P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

I am using SQL RS R2; It is a simple chart. Values are percentages, categories are just names and no defined series.

1) OK, in this case, suppose your original query is select Name, Percentage from Tab1 modify it as select Name, 'S1' as Series, Percentage from Tab1 union all select Name, 'S2' as Series, 0 as Percentage from Tab1 2) Put Percentage as datavalue,Name as category and Series in the series. 3) Make the chart as a stacked chart 4) Follow the steps in the blog below http://road-blogs.blogspot.com/2010/06/display-total-on-top-of-stacked-chart_8589.html The above blog actually shows how to display labels on the top. If you change the sorting, the labels will appear in the bottom. However note that for s2 series, the percentage is 0 which is why it would appear in the bottom, else it will not. You would need to make small changes but the logic is there. If you find it difficult, please shoot the questions here and I will explain it in more detail for u :) Cheers, Jason P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Hi Woyler, The "bottom" value for "LabelStyle" just places the data label in the column bar. This is by design in the current reporting services. However, there is a workaround to let the label to be closer to the X-Axis line, it is to override the label value using this expression =vbcrlf + vbcrlf + Cstr(SUM(Fields!Amount.value)). You can add more vb line feed in the expression to near to the base line, even though use the logical program to determine how many vbcrlf to be added in the expression like this: =IIF(SUM(Fields!Amount.value)>500,vbcrlf + vbcrlf + vbcrlf + Cstr(SUM(Fields!Amount.value)),vbcrlf + vbcrlf + Cstr(SUM(Fields!Amount.value))). Of course, if you have any concern about this problem, you can submit a feedback at http://connect.microsoft.com/sqlserver/feedback . hope this helpfully, thanks, Jerry

At this moment you can't force the "SmartLabel" usage, however it's high on my wish list as well. Although I managed to implement a workaround by doing the following: - Insert a “dummy” series in your chart and: o Add a maximum value (according to the axis value) or a null value o Set the “Category axis” to “Secondary” o Make sure that the “Fill” color is set to “no color” - Insert the appropriate expression for the label using the “Data Point/AxisLabel” When rendering your chart, you will see that the normal category labels will be shown at the X-axis, the “smart label” will be displayed at the other side of the chart (on top in case of e.g. vertical bar charts). Hope this helps, Frank van ZuilenFrank van Zuilen