Not able to show picture with multiple records

[dreamquartz]

Hello All,

I am struggling with the following:

I need to be able to list in a Writer form:
1. all participants of a certain project
2. project code
3. project name
4. date of project start
5. time of project start
6. date of finish of the project
7. the name of the project manager
8. title of the project manager
9. the picture of the project manager on one sheet.

I can create a project team and form, covering all but 9
The complete listings of the participants are shown in Writer using: Insert-> Field-> More Fields-> Datebase-> 'Next Record' for each new participant.

The picture is stored in their own specific folder in png format.

If I use LO Base Forms to design a form, I am able to show the picture of the project manager, but only one participant @ the time; it appears that the principle of 'Next Record', (see above) is not avaialble.
In Writer the principle is available, but not in Base, by the looks of it.

Any thoughts are really appreciated.

Dream

Disclaimer: Due to confidentiality requirements of the Client, we are really limited in providing more information.

[Bidouille]

Please provide an ODB containing the table structure and some data.

To upload an anonymized file, you can use a site like fakenamegenerator.com

[UnklDonald418]

If I use LO Base Forms to design a form, I am able to show the picture of the project manager, but only one participant @ the time

I'm assuming you have a normalized database where the team members are in a result set with each member in a separate row.
To display all of the team members at once on a form requires them all to appear in a single row which can be achieved by pivoting the result set. Unfortunately, HSQL 2.7 does not have a PIVOT function, so a little extra SQL is required.
I put together a demonstration of how I would approach the problem. Because the demo includes images I rolled it all in a zip archive that can be downloaded from: https://www.mediafire.com/file/vm4lkfj0 ... s.zip/file

Query_rn adds row numbers to the result set with the numbers restarting for each team. Query_C uses those row numbers to put them into columns.
There are 3 form documents. Teams is probably similar to what you had where team members can be displayed one at a time. It uses tables for data sources, so this is where any data Entry/Edit is done.
Teams01 has the result set pivoted which is done with Queries, so this form is read only, no editing of data is possible.
Teams02 is is similar to Teams01 with a reversed pivoting order,
Teams01 and Teams02 have a limit of 4 team members per team but with a little extra work could be expanded to 10 or 12 members. Beyond that, this approach may not be practical.

[dreamquartz]

That is (almost) exactly what I was trying to accomplish.
For example, in Writer we use the function 'Insert -> Field -> More Fields...Database - > Mail merge fields and Next record' to list the members of a project.
This works really well, because the placement of the resultset is transparent.
Trying to re-design the pre-printed forms that need to be used for displaying the resultsets is not an option, because the layout is mandated.

It appears therefore that I should have asked to see if the 'Table Control' can be made transparent, but that is probably to much to ask....

Will work on it further,

Dream

[Villeroy]

Instead of Writer, a report can be used to show all data with all pictures:
https://www.mediafire.com/file/l3n161t1 ... 2.zip/file

[dreamquartz]

Attached you will see a pdf-file, consisting of 3 pages, indicating what we are looking for.
pg 1 is the placement of the records on a picture background, where the project information can be manually filled out, dated, signed off, and commented.
pg 2 is the info provided from the database.
pg 3 is a basic layout of the database structure.

Our goal is to get the picture of the Project Manager, based on filling out a projectnumber.
NOTE: the pictures are stored in the Staff Folder for the Project Manager.

Dream
https://www.mediafire.com/file/s3ttd871 ... d.pdf/file