Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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

like image 835
BenYeomans Avatar asked Aug 22 '14 09:08

BenYeomans


3 Answers

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.

like image 61
William Avatar answered Nov 16 '22 00:11

William


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.

like image 25
SumoBI Avatar answered Nov 16 '22 00:11

SumoBI


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.

like image 27
PiotrWolkowski Avatar answered Nov 16 '22 01:11

PiotrWolkowski