Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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? ­­­­­­­­­­­­­­­­­­­­­­­­­­­

like image 967
Pulsehead Avatar asked Aug 25 '08 18:08

Pulsehead


People also ask

How do you make a multiline text box?

To create a multi-line text input, use the HTML <textarea> tag. You can set the size of a text area using the cols and rows attributes. It is used within a form, to allow users to input text over multiple rows.

What is a multi line text box?

A multiline text box control is a large text box that can display several lines of text or accept this text from user input. Text boxes are often linked to select value lookups and detailed menus. You can place a multiline text box control within a section control.

Is it used to enter multiple lines of data in a text box?

You can put multiple lines in a cell with pressing Alt + Enter keys simultaneously while entering texts. Pressing the Alt + Enter keys simultaneously helps you separate texts with different lines in one cell. With this shortcut key, you can split the cell contents into multiple lines at any position as you need.

How do I add a line break in SSRS expression?

Inserting a line break into a regular text box is as easy as hitting the Enter key unless you're using an expression, in which case those line breaks are ignored. This results in the insertion of non-printing carriage-return and linefeed characters (basically the equivalent of hitting the Enter key).


1 Answers

Alter the report's text box to:

= Fields!Addr1.Value + VbCrLf + 
  Fields!Addr2.Value + VbCrLf + 
  Fields!Addr3.Value
like image 187
Pulsehead Avatar answered Sep 24 '22 14:09

Pulsehead