Search code examples
excelreporting-servicesssrs-2008

SSRS Export to Excel not word wrapping

I have a report in SSRS that I am building. I have one column I want the header stacked on top of the other, as the data in that column is very small. When I Export it out to Excel it loses it's word wrap, and it gets cut off in the middle, making it the same size as the other headers. While in BIDS, it is word wrapping correctly.

In Excel: enter image description here

In BIDS: enter image description here

Code I am using on that column to get it to word wrap:

="Sku Express" & VBCRLF & "Classification"

I have the CanGrow set to True and the CanShrink to False

I've tried everything and I can't seem to get that column to properly expand.

Solution

  • So this question has an answer:

    Usually this happens where there is something else in the report, maybe in the page header that needs to be aligned to prevent this from happening. By moving some report objects around, making sure objects are all aligned, the export to Excel wraps the text as desired. Exports work with PDF just fine, but Excel chokes when alignments are off.