[Solved] Insert database columns with a macro in Writer

AfTech54 · Post by **AfTech54** » Wed Feb 12, 2020 1:14 pm

I'm trying to record a macro doing an insertion of a database search query into a .odt. I stop recording after hitting the OK in dialog "Insert database columns", the data is then inserted into the doc. When running the macro it stops with the dialog? If this require hands on programming of a macro I'll not going to use/continue with it.

Post by **RoryOF** » Wed Feb 12, 2020 2:17 pm

OpenOffice macro recorder is rudimentary. Often one will need to hand edit and extend the recorded code. If OpenOffice doesn't meet your needs, look for something that does.

edit this topic's initial post · Post by **Villeroy** » Wed Feb 12, 2020 3:32 pm

Create a database report. A database report is a Writer table filled with query data.
Query right-click>Create Report...

A macro driven alternative: [Writer] Stand-Alone Database Reports

AfTech54 · Post by **AfTech54** » Wed Feb 12, 2020 3:42 pm

OK both and thanks. The base report doesn't fullfill my needs.
I'll keep on doing it manually.

edit this topic's initial post · Post by **Villeroy** » Wed Feb 12, 2020 4:05 pm

There is a report builder extension which might fullfill your needs.
I use Calc as a report engine. It fullfulls my needs.

[Solved] Insert database columns with a macro in Writer

[Solved] Insert database columns with a macro in Writer

Re: How to insert database columns with a macro into Write

Re: How to insert database columns with a macro into Write

Re: How to insert database columns with a macro into Write

Re: [Solved]How to insert database columns with a macro in W