SSRS will not expand row height when exporting to Excel

Question

I have a report that I am doing with SSRS 2008 with some rows that have several elements. When previewing a row, it automatically expands to support additional elements, but when exporting a report to Excel, it appears only as one row with only one element displayed, although all elements are present when I double-click the row or manually expand It.

I checked everything ... It is possible that grow is set to true, and the properties in the text field can increase its height, but it seems to ignore it.

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

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

Sorry for the links to the photos, not to this question

Answer 1

Both CanGrow and CanShrink must be set to false . There is nothing like CanGrow and CanShrink . By setting them to false, the height will be displayed as is. Otherwise, the height value will be set by default.

It worked for me. Check the Row Height not saved when exporting to Excel for additional suggestions.

Answer 2

Both CanGrow and CanShrink properties must be set to false. This must be done for all cells in the Tablix row! Otherwise, the data will not be exported correctly.

Answer 3

I came across this (again) recently and thought that I would share my take ...

Whether Excel displays the height correctly is related to the merged columns. Pay attention to the alignment of columns for all objects on the page. Any objects that are not attached to the data table itself (or embedded in the data table) should be aligned on the columns of the table in question, at least for cells that should carry text. If there is any overlap leading to the separation of the columns of the table and the reunification of the wrapped text cells, Excel does not recognize the row height by setting CanGrow to True or by setting the row anchor in Excel.

In the original post, the user mentioned rows with several elements inside them. It is possible that these elements caused column splitting for surrounding subtotals or adjacent groups with portable text.

If the CanGrow parameter is set to False, then by default it will simply be prevented from automatically changing the line height for both the web view and export to Excel, so I don’t know if this is the ideal solution to this problem.

Answer 4

reduce line width and fix the problem

Answer 5

I delete the report title and everything works fine.

I have other reports, and now I see that if I delete the text fields included in the sheet when exporting to Excel, then the row height in Excel will be correctly determined.