Reporting services 2005 - rezising the legend size

Hi all,I have a report with a chart.the chart has a legend.The problem is that the number of categoried the legend contains grows in time.

How to i do i make the legend rezing dynamicly so that the text doesnt go over the other?

You could consider a "table" legend layout which may be able to better accomodate the legend items.

Other than that, you could look into building a custom legend by using a table data region instead of using the built-in legend (see this article for more details: http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx)

-- Robert

Reporting Service (Can i do this)

I wanted to create a document for a pre printed page. This page are divided in 3 parts of A4 size paper and the parts are tear off. If the data is increased it has to use 2 parts and the next document should start on the 3rd part. I also want to format the output so that its presentable (eg, use colors, tables and stuff). can i do this using SQL Reporting service?
Thanks in Advance
Yes,
I did this with a pre-printed form from a Lab environment - I had some initial problems - but at the end of the day it all worked out fine!
best regards,
joe|||U mean using colors and tables do u have any sample application for this? Or some link where i can find out more abt this?