Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Address format - to horizontal

Hi all,

A query - how can I change an address from being of the following format in Crystal Reports:

Tom Jones,

10 Downing Street,

London,

WZD 123

to the following format:

Tom Jones, 10 Downing Street, London, WZD 123

Now the complication is that these addresses are manual entries to the ORDR.Address2 entry on the Sales Order so do not have individual lines such as Floor, Block, Zip, etc to enable the traditional method of realignment.

Using Crystal Reports 2008, version 12.5.0.1191

Alan.

Tags:
Former Member
replied

Hi Alan,

Since these are 'manual' entries and all rows are part of the same field, I'm hoping they're separated by a 'line feed'. See if this works please:

Replace(Replace({Address_field},chr(13)," "),chr(10)," ")

-Abhilash

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question