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
Monday, March 19, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment