x

SSRS 2008 R2: How to add legend or scale for data bars

Hi all,

I'm creating a report in 2008 R2 that uses data bars in a column in a table. It would be useful to add a legend and scale somewhere (the column header, perhaps), but there doesn't seem to be any way to do this in BIDS.

Can anyone suggest how to add a legend or x-axis scale for the data bars?

Thanks alt text alt text

Note: I've edited this post to attach two images. One of what I have, and one of what I would like.
more ▼

asked Feb 28, 2012 at 10:26 AM in Default

xnl28 gravatar image

xnl28
895 56 60 62

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
Unfortunately, you are asking for features which are not available for Data Bars. Data Bars have the same basic chart elements of categories, series, and values, but they have no legend, axis lines, labels, or tick marks.
more ▼

answered Feb 28, 2012 at 10:46 AM

Usman Butt gravatar image

Usman Butt
13.9k 6 8 14

@Usman: Yes, I know these chart elements are not available for data bars. I'm hoping some of you out there have discovered some useful and clever way to emulate this :)
Feb 28, 2012 at 11:06 AM xnl28

Those sort of things depends upon the needs and in most cases may not be applicable to all scenarios. But I do not understand why you need a legend for Data Bars?

Anyways, this [blog][1] has a very impressive usage of Data Bars. It may guide you in right direction.

[1]: http://blogs.msdn.com/b/seanboon/archive/2009/11/23/an-introduction-to-data-bars-in-sql-server-reporting-services-2008-r2.aspx
Feb 28, 2012 at 11:13 AM Usman Butt
@Usman Butt: My data bar is stacked, so a legend in the header of the column containing the data bar that indicated what series the different colours are would be very useful.
Feb 28, 2012 at 12:35 PM xnl28
Can you please give an example with visuals? I hope you know the differences b/w bar charts, column charts and data bars. The most difficult part is when to use them :)
Feb 28, 2012 at 01:31 PM Usman Butt
I've edited my original post to attach images of what I have and what I'd like to achieve.
Feb 28, 2012 at 03:04 PM xnl28
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x84

asked: Feb 28, 2012 at 10:26 AM

Seen: 2415 times

Last Updated: Feb 28, 2012 at 03:04 PM