In Base, is there an easy way to export a report to an easily editable Writer document?
I have a database of names and addresses, and I want to convert it to a Writer document that I can reformat.
I can make a report with
Name
Addressline1
Addressline2
etc....
It's easy to create a Writer document, but each record finishes up in its own table. This has a problem: although the fields are in a single column in the report, the table has two columns and it doesn't seem to be possible to remove the second one.
in addition, I can't select the entire output and adjust the column widths as one - I have to select each record and do it one at a time. Rather time-consuming.
In the end, what I want to finish up with is a document with (probably) 3 columns. I don't mind if the records are vertically of horizontally arranged. But I can't see an easy way of doing this without writing a load of LO Basic.
Has anyone any ideas how to achieve what I want?
When I posted this, the report fields in the 2nd paragraph were vertically arranged - something in the formatting here has changed that.
@ptoye: this is an artefact caused by the markup language used on this site.
To force paragraph break, type
Enter
twice otherwise lines are joined like in HTML pages (anyway this site is based on HTML).To have preformatted text displayed as you typed it, suffix every line with 5 spaces.
You can have a try to it by editing your question.