Add Line Break in SSRS Expressions

• subasuga

  Mr or Mrs. 500

  Points: 510

  More actions

  August 4, 2010 at 12:31 am

  #387496

  Hi .

  How to add line break in the expression that retrieves data from the database.

  my expression goes like this.

  =Fields!Losses.Value

  Sum(Fields!totvalue.Value)&"("&

  Sum(Fields!totvalue.Value)/Sum(Fields!totvalue.Value, "DataSet1")*100&")"

  Right now am getting the output like this.

  DownLoss148(50)

  I want to display it as:

  DownLoss

  148

  (50)

  How to go abt it???

• August 4, 2010 at 3:33 am

  This was removed by the editor as SPAM

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  August 4, 2010 at 7:26 am

  #1202077

  I usually do it like this:

  =Fields!Losses.Value & VbCRLF &

  Sum(Fields!totvalue.Value) & VbCRLF &

  "(" & Sum(Fields!totvalue.Value)/Sum(Fields!totvalue.Value, "DataSet1")*100&")"

• subasuga

  Mr or Mrs. 500

  Points: 510

  More actions

  August 4, 2010 at 8:52 pm

  #1202461

  Thanks both of you for youe response....

  VbCRLF worked for me.:-)