How do I set a textbox to multi-line in SSRS?

Question

I have a report with many fields that I'm trying to get down to 1 page horizontally (I don't care whether it's 2 or 200 pages vertically... just don't want to have to deal with 2 pages wide by x pages long train-wreck). That said, it deals with contact information.

My idea was to do:

Name:      Address:   City:      State:    ...
Jon Doe    Addr1      ThisTown    XX       ...    
           Addr2
           Addr3
-----------------------------------------------
Jane Doe   Addr1      ThisTown    XX       ...
           Addr2
           Addr3
-----------------------------------------------

Is there some way to set a textbox to be multi-line (or the SQL result)? Have I missed something bloody obvious?

The CanGrow Property is on by default, and I've double checked that this is true. My problem is that I don't know how to force a line-break. I get the 3 address fields that just fills a line, then wraps to another. I've tried /n, \n (since I can never remember which is the correct slash to put), <br>, <br /> (since the report will be viewed in a ReportViewer control in an ASP.NET website). I can't think of any other ways to wrap the text.

Is there some way to get the results from the database as 3 lines of text/characters?

score 24 · Accepted Answer · edited Jul 14 '15 at 02:05

24

Alter the report's text box to:

= Fields!Addr1.Value + VbCrLf + 
  Fields!Addr2.Value + VbCrLf + 
  Fields!Addr3.Value

edited Jul 14 '15 at 02:05

Mosha Pasumansky

13,206
5
32
55

answered Aug 27 '08 at 15:15

Pulsehead

5,050
9
33
37

2

instead of using `VbCrLf` you may should use `System.Environment.NewLine` as best practices – WiiMaxx Jul 02 '14 at 10:53
2

@WiiMaxx And replace `+` to `&` – Sponsor Apr 04 '16 at 11:25

score 6 · Answer 2 · edited Jul 14 '15 at 02:25

6

I had an additional problem after putting in the chr(10) into the database.

In the field (within the report) add in:

=REPLACE(Fields!Addr1.Value, CHR(10), vbCrLf)

edited Jul 14 '15 at 02:25

Enamul Hassan

5,266
23
39
56

answered Aug 27 '10 at 09:27

Sam

61
1
1

score 5 · Answer 3 · answered May 28 '13 at 07:04

5

My data was captured in a SL application, needed this for the field expression

=REPLACE(Fields!Text.Value, CHR(13), vbCrLf)

answered May 28 '13 at 07:04

Adriaan Davel

710
1
11
25

the [post](http://stackoverflow.com/a/3582842/1993545) from Sam says already the same thing, so -1 for repeating – WiiMaxx Jul 02 '14 at 10:50
Used `System.Environment.NewLine` instead of `vbCrLf` as noted in another comment, other than that this worked perfect for me! – sǝɯɐſ Oct 16 '19 at 20:16

score 4 · Answer 4 · answered Jul 27 '11 at 19:07

4

Hitting Shift+Enter while typing in the textbox creates a line break.

answered Jul 27 '11 at 19:07

James An

1,383
1
10
16

Sean Carpenter · Answer 5 · 2008-08-26T11:46:57.127

2

I believe you need to set the CanGrow property to true on the Textbox. See http://msdn.microsoft.com/en-us/library/ms159116(SQL.90).aspx for some details.

edited Aug 26 '08 at 11:46

answered Aug 25 '08 at 21:30

Sean Carpenter

7,681
3
37
38

score 1 · Answer 6 · answered Nov 02 '09 at 20:48

1

link break do this

chr(10)

answered Nov 02 '09 at 20:48

zhengokusa

11
1

Please provide your answer some more detail. – suresh gopal Jan 07 '13 at 18:18

score 0 · Answer 7 · answered Feb 01 '17 at 18:02

0

Try this one :

= Fields!Field1.Value + System.Environment.NewLine + Fields!Field2.Value

answered Feb 01 '17 at 18:02

score 0 · Answer 8 · answered Aug 13 '17 at 05:06

0

In RDLC reports, you can convert a textbox to placehoder. Then right click that textbox placeholder, select placehoder properties and select HTML. Then for multiline to take effect, you have to insert <br/> tag between those lines.

answered Aug 13 '17 at 05:06

Hemal

3,682
1
23
54

How do I set a textbox to multi-line in SSRS?

8 Answers8

Linked