Solved

Problem when exporting to excel - row height not expanding

Posted on 2008-10-19
2
2,711 Views
Last Modified: 2008-10-22
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
Comment
Question by:2575069
2 Comments
 
LVL 9

Accepted Solution

by:
Sander Stad earned 500 total points
ID: 22756103
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
 

Author Comment

by:2575069
ID: 22781965
Hi....
Thats perfect site.......It worked fine.........
Thanks for  the help.........
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now