How to display images from Base in Writer?

English
,
#1

I created a small database in LibreOffice Base and one of the tables (photoTable) contains columns id (integer), description (Text [VARCHAR]) and photo (Text [VARCHAR]).
The database is registered in LibreOffice.
I fill in the table via the form I created - entering the description and selecting the appropriate photo.
Next, I created a query and saved it as a QPhotoTable:

select description, photo from photoTable

The query is executed successfully by showing a description of the photo for the description column and a relative path to the photo for the photo column.
Photos are stored separately from the Base file. So in another folder.

The question is how do I display the contents of a table from LibreOffice Base, especially a photo, in LibreOffice Writer? I know how to display numbers or text.
If you need any more information, I am at your disposal.

#2

I think the fastest solution is to use Listing 5.30: Find and embed an images from Chapter 5.9.3.3. Embed multiple images. Of course, you will also need macros from the previous two chapters.

Or if it is not important for you where to get the result - in the Writer or in the Calc spreadsheet - then you can use the Links to images extension

#4

Sorry it is not solution I was looking for. I need to generate final odt document(s) from database.
Also Link to Images extension works only in Calc

#3

One of the quick solutions is to put an “image control” in a report. The datasource for the control is the field in the database wich holds the path to the picture.

But take care: reports are generated as large tables in writer. So may not be stable for several hundred pictures…

1 Like
#5

Where is “image control” in a report?

#6

If you are using the report builder (could be it isn’t installed on Ubuntu and some of these systems by default) open the report for editing.
Choose Insert → Report Controls → Image or the fifth button on the on toolbar.

#7

Ok I understand what are you talking about. My workflor can not be done with Reports builder. It must be done via Writer.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.