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:
- Create a report using Xtreme sample database with Customer table
- 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 Business View Manager , How To
Product
SAP Crystal Reports XI R2