SAP Knowledge Base Article - Public

1251345 - How to use carriage return in Crystal Reports formula

Symptom

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

Reproducing the Issue

Environment Information:

  •   Crystal Reports Designer XI and above

Resolution

  • 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

Keywords

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

Product

SAP Crystal Reports XI R2