SSRS2012 export to excel not working like SSRS2008
Posted on 2013-01-08
I am converting a report from ssrs 2008 to ssrs 2012 (just imported the 2008 report into 2012). The report is fine when it renders (and also pdf) and also prints fine. All on one page for width. Row size perfect.
When I export to excel the row height changes and it now prints over one page in width.
In one of my columns I have a text. This text is larger than the column so it only displays say the first 20 letters. If the user wants to see the rest they can do so in Excel (change row height or column width etc). By default, I don't want the display to show what is wrapped (only the first 20 letters). In ssrs 2008 it was only showing those first few characters. Now it shows the first slice that is wrapped to the next line. I went into the row height property and found that it was 13.2 in SSRS2008 and 14.4 in SSRS2012.
I'm also having an issue with each column getting slightly bigger in SSRS2012 and now it goes to two pages. One particular column the width changes from 4.22 (SSRS2008) to 4.33 (SSRS2012).
How do I get this 2012 report to export the same way it does in 2008?