Issue while exporting RDL reports with many columns to excel
RDL report I am working on has a table which has 12 columns. All column widhts have been decresed so as to make the table fit in the report. While I export the report to PDF, it looks good. The same is not the case with excel. The text does not appear in multiline but appears crushed in a single line. When I remove some of the columns and increase the widht, it works in excel but the report requires all the columns. And "CanGrow" is set to true. Is this some exel limitation ? Workarounds ?
October 12th, 2010 7:48am
Hi Manisha, There is no way to fix it in the current reporting services. I would suggest you submit a feedback at https://connect.microsoft.com/SQLServer/Feedback and hope microsoft release some service pack to solve it. thanks, Jerry
October 14th, 2010 6:44am