Problem when exporting to excel - row height not expanding
Posted on 2008-10-19
I am having a report (using SSRS 2005). when I am viewing it in the Preview tab its working fine and when I am exporting to PDF also its working fine.
But, When I am exporting the report to Excel, I am facing the following problem..........
The row height for rows with multiple lines, does not expand . So the users has to manually increase the height of rows in excel.
For example, I have a column named "COMMENTS" in my report and it has many lines included per row.........when I export to pdf, I can see all information each row has........but when I export to excel, I was able to see only one line per row..........if I want to see all information a row contains, then I have to manually increase the row height.........
So, I just want to know how to resolve the above issue when exported to excel so that I can view all information a row has...........