I am getting text information from our SQL database which unfortunately comes in from a text field which as everything in a block.
it is customer delivery address and come in like the example below
12 Norwood Road
If I show this in the details section it makes the report far to big with lots of pages.
Is there a way I can make the field so the text would read
12 Norwood Road, Southall, Middlesex, UB2 4LL
Not bothered about the comma separator, but if I could get the text in one line that would be great.
Any ideas please if this is possible