I didn’t find a solution for my current issue:
(for information, I used LibreOffice 7 with a Firebird embedded database, on a Debian desktop).
In a report (Base), I want to display pictures that are not attached in the database but referenced through their file name.
Based on this thread, I could correctly display a picture in the report, by providing the full file path in the adequate field.
But what I would like is to work with relative path better than full absolute links (note: picture are stored locally, not online).
Indeed, the database+pictures folder will be shared to other people, using different desktop OS, and probably placed in different locations in the target computers.
In other words, I would like that the report adequately display the pictures if the working folder is placed for example in:
- /home/greb/documents/database/, and
Is there a way maybe through the formula function in the “Data field” field of the image control?
(Ive tried the URLENCODE function, but not sure that it’s the appropriate function, and don’t know how to use…)
Thanks a lot in advance for any help or tip!