Monday, 25 October 2010

New Line in a Text Box

In a text box field you can use the following code to force reporting services to start a next line.


'This the first line'+ VBCRLF +
'This is the second line'+ VBCRLF +
'This is the third'
at

3 comments:

  1. Unknown12 June 2013 at 09:01

    HI,
    Try this:
    'This the first line'& VBCRLF &
    'This is the second line'& VBCRLF &
    'This is the third'

    ReplyDelete
  2. abs23 July 2013 at 14:40

    Does the & make any difference are they any advantages in using it?

    ReplyDelete
  3. Unknown10 January 2014 at 06:40

    after importing this report into excel sheet, its coming in only 1 row.can anyone help plz ?

    ReplyDelete

Subscribe to: Post Comments (Atom)

Keep SSRS (SSRS2016) report manager awake

When running a report for the first time in report manager it takes a while to run, after this initial run reports run fine.  There are a ...

  • Subscriptions SQL query
    Due to the fact the reporting services allows you to query the tables you can easily write SQL which will allow you to return data from the ...
  • Conditional Page Breaks in SSRS 2008 r2
    I have recently been looking at conditional page breaks in SSRS 2008 r2 and did not know that it is possible to do via an expression. For...
  • Alternate Colors in a Matrix/Pivot Table
    To add alternate colors in a matrix the expression should be as follows for the row group: =IIf( RunningValue (Fields!FIELDNAME.Value, Co...