question

AbhishekSrivastava-1135 avatar image
0 Votes"
AbhishekSrivastava-1135 asked TomDale-5812 published

Is it possible to disable wrap text in SsRs

I have a Ssrs report and I want to download the Ssrs data on excel but the text in any column should not be wrap. Means the text should be visible in a single line.

sql-server-reporting-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AbhishekSrivastava-1135 ,
Has your issue been resolved?
If you have any questions, please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and upvote it.
Best Regards,
Joy

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered AbhishekSrivastava-1135 commented

Means the text should be visible in a single line.

Not very clear what you mean? May can you post an example?

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I have a SSRS report, where I am dislaying a data. There are few columns in the report whose text is big and on the report, it is showing in a multiple lines in a column. I don't want to show the data like this. The data should not be wrap and should come in a single line.

0 Votes 0 ·

As an example -

" This is a
Sample data"

Should display like " This is a Sample data"

0 Votes 0 ·
Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

Hi @AbhishekSrivastava-1135 ,
There are CanGrow and CanShrink properties to control the text box expand or shrink vertically based on its contents. However, the CanGrow property only indicates that the text box height can increase to accommodate the contents but not the width.

By design, width of textbox or table column is always static. So, in order to prevent the word wrapping, please increase the width of the column if possible.

Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CorySGB-7996 avatar image
0 Votes"
CorySGB-7996 answered

I know this is a bit late but I get around this by adjusting the Top and Bottom Padding and setting the Can Grow property to False.
The only problem is, if the string is too long to display, it trims at the space and moves the remainder of the string to the next line, which is not displayed.

The O.P. Wanted something like:
THIS IS A STRING THAT I WANT TO TRUNCATE
To appear in a fixed-width column as:
THIS IS A STRING THAT I WANT T
Instead of:
THIS IS A STRING THAT I WANT
TO TRUNCATE
With SSRS and my suggested solution, you would get:
THIS IS A STRING THAT I WANT

Sadly, this is less effective with longer words. I feel that the community would like a behaviour similar to Excel, where the text within a cell is simply printed right up to the beginning of the next cell (providing it is not empty).
|Text in cell 'A' goes up to he|Text in cell 'B' goes up to here because it's a wider column. |Cell 'C' |

I hope that's enough examples to demonstrate the intention.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomDale-5812 avatar image
0 Votes"
TomDale-5812 answered TomDale-5812 published

Has there been any other updates on this subject? We tried the can grow/shrink properties but it does not work.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.