How do I change a single line textbox into multi line in SSRS reports?

Question

0.00/5 (No votes)

See more:

VS2010

Hello,

i am using visual studio 10 to create SSRS report. in this, i have a textbox which is having an Expr value i.e. value = First(Fields!n1.value, "GetAll"), where n1.value contains multiple lines of text i.e.

Test
Test
Test

But when viewing report, it shows like this:-
TestTestTest.

I want the above value in multi line. how can i do this?

thanks very much.

Tamal Maiti

Posted 19-May-15 3:26am

Tamal Maiti

Add a Solution

1 solution

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)

Richard Deeming · Answer 1 · 2015-05-19T04:16:00

Solution 1

It depends how the line-breaks are encoded within the source data.

Line-breaks encoded as a carriage-return (ASCII code 13) followed by a line-feed (ASCII code 10) will display as expected.

For anything else, you'll need to replace the line break with vbCrLf:

VB.NET

=Replace(First(Fields!n1.Value, "GetAll"), Chr(13), vbCrLf)

Posted 19-May-15 4:16am

Richard Deeming

Comments

Tamal Maiti 19-May-15 13:21pm

Thanks for the solution Richard. But I tried it, its not working in my case.

Richard Deeming 19-May-15 13:25pm

You'll need to look at the raw data in a hex editor to see how the line breaks are encoded.