ssrs export to excel wrap text issue

Question

1.00/5 (1 vote)

See more:

Hi All

In ssrs reports (sql server) when I try to export the report in excel, the columns have wrap text option as enabled. I want to disable it. Please suggest..

Posted 21-Feb-12 5:59am

Akshat Bhasin

Updated 21-Jun-17 0:53am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ganesan Senthilvel · Answer 1 · 2012-02-21T19:23:00

Solution 1

By default, if text does not fit, the textbox will display text in wrap model. However, when set the CanGrow property to False, the textbox will only display the first line of text

SQL

set CanGrow = false

Posted 21-Feb-12 19:23pm

Ganesan Senthilvel

KapilMuni · Answer 2 · 2017-06-21T00:53:00

Solution 4

IT happens when you merge Two or more column to show resultset , Remove all your merge Column and split it , then set CanGrow properties:- True. it will work .

Posted 21-Jun-17 0:53am

KapilMuni