sql server reporting services: Height and Width -- sql server reporting services

Height and Width

Mandoskippy
8/4/2006 10:31:59 AM

sql server reporting services:

I have a chart that is a simple sie chart. In some cases, the number of
items in the pie chart can be high (say 20 items) in these cases, the
legden gets ugly because the graph height is too small to accomadate
the number of items... is there a way I could change some of those
dynamically to make it look better? Can expressions be used for
"height" ? One method I though was making the font size a little bit
smaller for large numbers of items... this would work, but how would I
write an expression based on the number of rows in my dataset?

Thanks in advance!

Re: Height and Width

Mandoskippy
8/11/2006 6:38:17 AM

=iif(CountRows("%DATASET%") > 15, "8pt", "10pt")

This expression is used for my legend font size.. .it helps... but I
wish we could adjst height!!!!!

[quoted text, click to view]

Re: Height and Width

Mandoskippy
8/11/2006 6:38:42 AM

Oh... replace the %DATASET% with your dataset name
[quoted text, click to view]

Re: Height and Width

nickismyname
8/15/2006 1:54:27 PM

Thanks mate will give it a try
[quoted text, click to view]

Re: Height and Width

msflinx
8/22/2006 9:02:02 AM

I, too, share this issue.

Did you find anyway to adjust the height?

I already have my font down to 6pt, and it's still not small enough. Can't
go too much smaller, because of readability

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.