Matrix report export to Excel

I created a report based on matrix.
I set the can grow property of all fields to false.
In the report the fields are behaving as expected - the size is fixed.
When I'm exporting to excel the fields are growing according to the text size.
(I have other report based on table and the can grow property controls the
fields alos when exporting to excel).
How can I control the can grow?
Thak'sHello,
It seems that you're running into a limitation in Excel. When there are
merged cells in a row, Excel cannot apply it's equivalent of CanGrow on the
row. You're likely running into merged cells due to the layout of your
report. If items in the report don't line up with each other vertically,
SRS are forced to span items across multiple cells in order to preserve
your layout.
I have forwarded your feedback to the product team. In the meantime, I also
encourage you submit via the link below
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Please note that the newsgroups are staffed weekdays with a goal to provide
ONE BUSINESS DAY RESPONSE to all posts.
If this response time does not meet your needs, please contact CSS for more
immediate assistance:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;OfferProPhone#faq607

Matrix Cell Height?

Is there any way to get the Reporting Server to preserve the height of a cell
in a matrix? Currently, i set CanGrow and CanShrink to false (because i've
already designed the matrix cells to fit the text). However, with these both
set to false, the height is automatically changed to about 50 pixels, and i
can't get it to not do that.
Anyone know how to do this? Please help.
--whitOn Apr 25, 9:50 am, Whitney Yiu <Whitney...@.discussions.microsoft.com>
wrote:
> Is there any way to get the Reporting Server to preserve the height of a cell
> in a matrix? Currently, i set CanGrow and CanShrink to false (because i've
> already designed the matrix cells to fit the text). However, with these both
> set to false, the height is automatically changed to about 50 pixels, and i
> can't get it to not do that.
> Anyone know how to do this? Please help.
> --whit
Check each cell of the matrix control and make sure that 'Can increase
to accommodate contents' and 'Can decrease to accommodate contents'
are not selected as part of the properties (Format tab). Hope this
helps.
Regards,
Enrique Martinez
Sr. Software Consultant