Reputation: 383

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

Upvotes: 16

Answers (8)

ourmandave

Reputation: 1585

I had a comment block with 8 lines I couldn't get to auto height in a merged columns cell no matter what I tried.

Finally cut it up into 8 separate rows below the main detail row with conditional row visibility on each and turned off the top and bottom borders except for the first and last row.

You can't have nice things ~ SSRS

Upvotes: 1

Filip

Reputation: 11

Setting the CanGrow and CanShrink settings to False solved the problem for me.

The problem I had was that some rows (merged or not) in tables would shrink (despite CanShrink = False).

I am using PBI Report Builder v. 15.7.

HTH

Upvotes: 1

J West

Reputation: 13

I know this is an old question but I've been struggling with it. My issue was that I had a second field in a column where I inserted a placeholder underneath the field in the column. When exporting to Excel I wanted it to be tall enough that the second field would show underneath the main field in the column.

To get it to work for me, I inserted a blank column next to it and made it just wide enough for a single character. Then I click and hit enter several times to force it to be multiple lines. When I export, I have a blank column but otherwise it worked for me.

Upvotes: 0

SumoBI

Reputation: 121

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.

Upvotes: 12

Hugues Gauthier

Reputation: 669

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.

Upvotes: 1

William

Reputation: 71

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.

Upvotes: 7

PiotrWolkowski

Reputation: 8792

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.

Upvotes: 34

BenYeomans

Reputation: 383

reduce the widths of the rows and it fixed my problem

Upvotes: 0

SSRS won&#39;t expand the row height when exported to Excel

Answers (8)

Related Questions

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