SSRS won't expand the row height when exported to Excel

Question

I have a report I am doing with SSRS 2008 with some rows that have multiple elements inside them. On the preview the row automatically expands to support the extra elements but however when I export the report to Excel it appears only as a single row with just the one element displayed, although all the elements are there when I double click the row or manually expand it.

I've checked everything...Can grow is set to true and the properties on the text box allows it's height to increase however it seems to ignore these.

Here it is in the preview http://tinypic.com/r/b4wbdg/8

In Excel http://tinypic.com/r/r084g3/8

Sorry about the links to the pictures and not in this question

Answer 1

Both CanGrow and CanShrink properties should be set to false. There is nothing like CanGrow and CanShrink in Excel. By setting them to false it will display the height as it is. Otherwise it will set the height to a default value.

This worked for me. Check this Row height not preserved when exporting to Excel thread for more suggestions.

Answer 2

Came across this (again) recently and thought I'd share my take...

Whether Excel correctly renders the height has to do with merged columns. Take note of your column alignments throughout all objects on the page. Any objects not tied to the data table itself (or embedded inside the data table) must be aligned with the columns of the table in question, at least for the cells that need to wrap text. If there is any overlap causing the table columns to be split and the cells of wrapped text to be re-merged, Excel will not recognize the row height by either setting the CanGrow to True or snapping the row to fit within Excel.

In the original post, the user mentioned rows with multiple elements inside of them. It is possible that those elements caused the column to split for the surrounding subtotals or adjacent groups with wrapped text.

Setting the CanGrow to False will simply prevent any automatic sizing of the row height by default for both the web view and Excel export, so I don't know if that's the ideal solution to this problem.

Answer 3

Both CanGrow and CanShrink properties should be set to false This must be done for all cells in the row of the Tablix!! Otherwise the data is not properly exported.

Answer 4

reduce the widths of the rows and it fixed my problem

Answer 5

I remove the header of the report, and all works perfectly.

I have other reports and I see now that if I remove the textboxes that are included on the sheet when exporting to excel, then the row heights in excel are sized properly.