Line break in an expression used in a multi-line textbox

Line break in an expression used in a multi-line textbox

Posted by: rdillon on 31 May 2023, 4:15 am EST

• 

  rdillon

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 31 May 2023, 4:15 am EST

  We have a multi-line text box who’s value is an expression of a literal string and a field value. Like this:
  
  =“STATE SUMMARY REPORT”+First(Fields!Level3Name.Value, “DataSet1”)

  I would like there to be a line break so the Level3Name field is on a new line. How can I do that in the expression editor?

  I’ve tried concatenating in a
  
  and a “/n” and have even done a ctrl+enter but none of them add a break when the report is displayed. Is there a special Expression variable I can enter to force a line break a specific location?

  Thank you.

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 31 May 2023, 9:36 pm EST

  Hi Renee,

  ActiveReports Page/RDL Reports use VB.NET for expression and Script so you can add ‘vbLF’ for a linebreak in your string.
  
  Refer to the expression below:

  =“STATE SUMMARY REPORT” + vbLF + First(Fields!Level3Name.Value, “DataSet1”)
  

  Please find attached a report implementing the same.

  Regards,
  
  Anand

  LineBreakReport.zip

• 

  rdillon

  • Post Options:
  • Link
    Copy

  Posted 1 June 2023, 10:01 am EST

  That worked perfect! Thank you!