SAP Knowledge Base Article - Public

1251345 - How to use carriage return in Crystal Reports formula

Symptom

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

Reproducing the Issue

Surroundings Information:

  •   Crystals Reports Designer XI and above

Resolving

  • 1) Use ChrW() function.  ChrW() function returns one single type 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 instance:
    1. Create a report using Xtreme sample database using Custom table
    2. Open Method Editor and type in the following formula {Customer.Customer Name} & ChrW(10) & {Customer.Address1} 

         Output for beginning record is:

         Metropolis Cyclists

         7464 South Kingsway

Keywords

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

Product

SAP Crystal Reports XI R2