Chart legend wrapping

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matt - 31 May 2005 11:20 GMT

We have very long names for our series that appear in a chart legend so they
appear cut off with an ellipsis (three dots ...) at the end. We noticed
though that if we specify a \n in any one of the series names then they will
all wrap over two lines!

Ideally we would like the series names to all wrap over two lines in the
legend without having to specify \n in one of then - otherwise we would need
to carefully calculate where to add the \n

Is this possible to configure so that the metric names will automatically
wrap over two lines?

Reply to this Message

Robert Bruckner [MSFT] - 31 May 2005 21:21 GMT

You could write a function which uses GDI calls to calculate the actual
width of string glyphs based on font name, etc. However, the GDI calls are
usually not 100% accurate.

Another option to consider is to "draw" the legend by using a table report
item, rather using the built-in legend of the chart. Please check this
related newsgroup posting:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.
reportingsvcs&mid=ef87e605-48af-4c87-ac3f-ad43cd5fb1fc&sloc=en-us
Also check this blog posting which includes a link to a sample report.
http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx

Signature

Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.

> We have very long names for our series that appear in a chart legend so
> they
[quoted text clipped - 10 lines]
> Is this possible to configure so that the metric names will automatically
> wrap over two lines?

Reply to this Message