[Solved] Cannot get images in report to function properly
Posted: Sun Mar 20, 2016 1:38 pm
Hello,
I am a beginner at Base although I have used MS Access a bit before so I am familiar with the concept.
I am trying to learn Base by creating a database over Grail watches.
I have created one table for watches, one for manufacturers, one for different clockworks and one for different types of watertightness.
The manufacturers, clockworks and watertightness consists of one column each and the watches table consists of a few columns such as name, price, image url, type, manufacturer, watertightness and clockwork.
I have created a form to populate the watches table, including a image field which i can dubbelcklick to get a dialog to select the desired image.
The form seem to work fine, and it populates the table as expected including the image_url. I can create another form which can show information about each watch including its image. So the populated information seems to be ok.
Now to my issue.
I have tried to create a report to show each record one after the other together with the image for each watch so that I would create a list or catalog of sorts of all the watches.
First of all I find it very hard to arrange the layout of the report which might be part of my problem. The report wizard creates a one row table which shows each text record and I cannot seem to edit this in any good way so I tried to create another column in the table and add a image field with the image_url as data source. At best I only get a image for the first record, but sometimes the image seems to disapear behind the text and is not visible at all.
In the added image I added the image field to an existing column, and get it to only show for the first record. If I change the image_url for the first image the image will change so it does take the correct image for the first record.
What do I do to make images appear for each record?
Please help me to get me on my way.
I am a beginner at Base although I have used MS Access a bit before so I am familiar with the concept.
I am trying to learn Base by creating a database over Grail watches.
I have created one table for watches, one for manufacturers, one for different clockworks and one for different types of watertightness.
The manufacturers, clockworks and watertightness consists of one column each and the watches table consists of a few columns such as name, price, image url, type, manufacturer, watertightness and clockwork.
I have created a form to populate the watches table, including a image field which i can dubbelcklick to get a dialog to select the desired image.
The form seem to work fine, and it populates the table as expected including the image_url. I can create another form which can show information about each watch including its image. So the populated information seems to be ok.
Now to my issue.
I have tried to create a report to show each record one after the other together with the image for each watch so that I would create a list or catalog of sorts of all the watches.
First of all I find it very hard to arrange the layout of the report which might be part of my problem. The report wizard creates a one row table which shows each text record and I cannot seem to edit this in any good way so I tried to create another column in the table and add a image field with the image_url as data source. At best I only get a image for the first record, but sometimes the image seems to disapear behind the text and is not visible at all.
In the added image I added the image field to an existing column, and get it to only show for the first record. If I change the image_url for the first image the image will change so it does take the correct image for the first record.
What do I do to make images appear for each record?
Please help me to get me on my way.