how to put images into a report

users
#1

Hi,

how can I put images into a report?

I have a query on a database that, amongst others, has a field with the file name of an image. All images are stored in a particular directory, so the relevant table in the database holds the file name of the image, for example "abc.jpg". I need the image that has the particular file name displayed in the report.

The images are of different sizes, and in the first step, I'd like to have them scaled to fit into the report, and their aspect ratio must not be changed. In a second step, I might use some external tool to make all images the same size eventually.

#2

Hi,

how can I put images into a report?

Read answer 2 in the link below - caveat that it appears broken on OSX :

http://ask.libreoffice.org/en/question/27964/external-links-to-images-in-base-reports/

Alex

#3

For general resizing of images I like "Fast Image (JPG) Resizer for Java"

At: http://fir4j.sourceforge.net/

It will make each image the same size and fill in with your color choice around the image but you have to do the manipulation each time you add an image.

If you are using linux and can do scripting you can use the "inoticoming" command to watch you input-image-directory and output to you database-image-directory.

In the script you will have to manipulate the image with something.
You can try ImageMagick. See "How to Quickly Resize, Convert & Modify Images from the Linux Terminal"

At: http://www.howtogeek.com/109369/how-to-quickly-resize-convert-modify-images-from-the-linux-terminal/

I do not know if Apple products have the same or similar functions.

Hope this helps