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...........
raaj
Member
4 Points
33 Posts
Problem when exporting to excel - row height not increasing
Oct 19, 2008 11:29 PM|LINK
Hi Guys,
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...........
Thanks,
Raaj........................
SSRS 2005
IrfanUllah
Member
61 Points
83 Posts
Re: Problem when exporting to excel - row height not increasing
Oct 22, 2008 01:15 PM|LINK
i am also facing the same problem please any one help us out
Irfan Ullah
Mark as Answer to those post that helps you!
lmcculloch
Member
110 Points
27 Posts
Re: Problem when exporting to excel - row height not increasing
Oct 22, 2008 04:38 PM|LINK
While I don't have a specific answer for you, this link has a lot of details about what Excel can or cannot do regarding exports from SSRS:
http://msdn.microsoft.com/en-us/library/ms159836.aspx
I hope it is helpful.
raaj
Member
4 Points
33 Posts
Re: Problem when exporting to excel - row height not increasing
Oct 22, 2008 10:15 PM|LINK
ok guys,
I found the solution..........
Here is the link which explains clearly....
http://www.kodyaz.com/articles/reporting-services-excel-rendering-autogrow.aspx
Thanks............