Correct wrap text in SSRS, 2008 Excel Export

Hi SubhadipRoy,

Based on my research, whether to wrap text or not is depended on the last column header in the table or matrix. If we set the CanGrow property of last column header to true, then the header row of table (matrix) will be expanded. If we set the CanGrow property of last column header to false, the header row will be shrunk as the designed size.

So in your scenario, we can try to set the CanGrow property of last column header to true in Reporting Services level. Alternatively, we can click the Wrap Text button to enable the expended extra-long text property in Excel level.

If there are any other questions, please feel free to ask.

Thanks,

Katherine Xiong

---

Katherine Xiong

TechNet Community Support