?
Solved

Problem when exporting to excel - row height not expanding

Posted on 2008-10-19
2
Medium Priority
?
2,860 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 9

Accepted Solution

by:
Sander Stad earned 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

765 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