SAP Knowledge Base Article - Public

1251345 - How to use carriage return in Crystal Reports formula


How to display data returned by a formula on multiple lines?

Reproducing the Issue

Environment Information:

  •   Crystal Reports Designer XI and above


  • 1) Use ChrW() function.  ChrW() function returns a single character and when 10 is passed as a parameter, it returns a ‘carriage return’.
  • It can be used like {Field_1} & ChrW(10) & {Field_2} For example:
    1. Create a report using Xtreme sample database with Customer table
    2. Open Formula Editor and type in the following formula {Customer.Customer Name} & ChrW(10) & {Customer.Address1} 

         Output for first record is:

         City Cyclists

         7464 South Kingsway


KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To


SAP Crystal Reports XI R2