I have a simple report (SSRS 2008) with a tablix control with a few fields (textboxes). When the report is rendered to the screen, the column automatically expands to hold the longest data item in the field. Great - this is what I want.
But when I export the report to Excel, the column is not autofitted, and longer text values are wrapped in the cell.
In addition to this, the cells that have wrapped do NOT increase in height, even though the Textbox property "Allow height to increase" is selected. This means the text that has wrapped to the second and thhird lines are not immediately visible in Excel - the user has to click on the cell or increase the row height themselves.
Does anyone know how to get around this?
asked May 01, 2012 at 01:38 PM in Default
Not really is the answer, there's no real way to control what excel does the to the report once it's exported. It should honour all the formatting options you set but I seem to remember that auto grow isn't one of the better ones.
Have you tried creating a basic dummy report and seeing if auto grow works on that. I know there are some combination of formatting etc in tablix that break things like the auto grow on export
answered May 01, 2012 at 02:49 PM