How to uutofit text when rendered in Excel

Hi
We are facing following issue in SQL Server Reporting Service 2000.
We are generating report in excel format using reporting service. We are
unable to format the column width and height based on the content. We tried
couple of option like CanDraw and CanShrink, but it did not work.
We would like know if this is feasible to achieve or is it limitation in
Reporting ServiceFYI: I am having similar difficulties. The report looks find in the Report
Manager, but when it's saved to Excel, text wrapping is lost.
Karen
"Omnibuzz" wrote:
> Hi
> We are facing following issue in SQL Server Reporting Service 2000.
> We are generating report in excel format using reporting service. We are
> unable to format the column width and height based on the content. We tried
> couple of option like CanDraw and CanShrink, but it did not work.
> We would like know if this is feasible to achieve or is it limitation in
> Reporting Service
>sql