I'm trying to use a report to export an address

To do that I tried a field whose content is
=field.value("civilite")+" "+field.value("prenom")+" "+field.value("nom")+"\n"+field.value("adresse1")+"\n"+field.value("adresse2")+"\n"+field.value("codepays")+" "+field.value("code")+" "+field.value("commune")

according to information in viewtopic.php?f=221&t=107490#p249052
the result is a perfect 4 rows display.

Unfortunately none of the 4 export possibility keeps the 4 rows structure
text shows only the content of the 1st field, and spreasheet and html (CSS or not) shows the whole address but on one row

So the only way seems to be taking a screen copy

Hi Robert,
Shamelessly answering one year later

I tested on a table like this.

To get four I've put this as the Data Source property of a plain text Field report element:

Code: Select all

=field.value("date")+"\n"+field.value("uptime")+"\n"+field.value("dns")+"\n"+field.value("connect")

Please look at the table design, I set the "Can Grow" property to True, so the Field grows if needed:

here

This works in Kexi 2.8 at least:

here

Hope this helps.