Ask Your Question
0

Image in Reports Base

asked 2018-02-03 17:46:31 +0100

VHM gravatar image

Hello guys,

I read all the other questions about this topic but unfortunately, I still have troubles. My computer is a MAC OS X 10.11 LO version is 5.3.6.1

I include a LONGVARBINARY in a table as a read here in other question. This table I using to a report. I created a report and I insert the image and in the "graphics" I insert the path to the image. In the properties, everything is YES (preserve as a link, visible, etc).

In edit mode, I can see the image. When I run the report, the image disappears. I tried everything that I can according to with the other questions that I read here, but nothing works. Only in the edit mode, I can see the image.

Thank you for your help. VIctor

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-02-05 02:46:21 +0100

Ratslinger gravatar image

Hello,

Let me state I have no hands on experience with Mac OS X but don't think it really applies here.

You have a confusing statement in your question. Not certain of the database type you are using. You would use a LONGVARBINARY field in an embedded DB for embedded images (not recommended since just a few of these will crash Base). But then you state "...and I insert the image and in the "graphics" I insert the path to the image.". If embedding the image, there is no path to the image. If saving as a link (OK method for embedded DB) then you would just need a VARCHAR field. Most other DB's can & should use BLOB fields (MySQL for one).

Another note, have not yet seen where image is viewed in edit mode but not otherwise. A sample from you may possibly help in this matter.

Also have seen where images just don't work at all in Report Builder. This has occurred in different conditions with different databases. So please include you DB type being used.

Have attached a sample (one record) file which has a form & report and works on my system without a problem. LO v5.4.3.2 on Mint 18.3. It may help if this works OK on your system. It is an embedded image, not linked.

Sample - PictBlob.odb

edit flag offensive delete link more

Comments

Hello @Ratslinger, thank you for your answer and I am sorry for the late response because I am a volunteer in a school and once a week I work on this project. Your sample works well here on my computer, I am trying to solve the problem. I am using Base (LibreOffice) version 5.3.6.1. Thank you, Victor

VHM gravatar imageVHM ( 2018-02-14 21:16:22 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-02-03 17:46:31 +0100

Seen: 60 times

Last updated: Feb 05 '18