Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2959
  • Last Modified:

Problem when exporting to excel - row height not expanding

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,
0
2575069
Asked:
2575069
1 Solution
 
Sander StadSysteemontwikkelaar, Database AdministratorCommented:
This website can probably help you. It lets you enable the CanGrow property in your fields.
http://www.kodyaz.com/articles/reporting-services-excel-rendering-autogrow.aspx 
0
 
2575069Author Commented:
Hi....
Thats perfect site.......It worked fine.........
Thanks for  the help.........
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now