Would like to create one page report for each record in database table

As I mentioned earlier, I’m not really a technical person, so I hope that everyone will have patience if my terminology is not correct, but I will do my best to explain what I’m trying to do.

To begin with, I now have a database table which I created from a spreadsheet, and I believe that process went smoothly without any problems.

I would like to use my database table to create a one page report (or form?) for each record (or row) within the table.

It seems that I was able to do this many many years ago using MS Access, but I cannot figure out how to do this in base. (I know that they are two different products, but maybe there is a way to do this?)

I’ve included examples of the original spreadsheet, the database table, and an example of the type of report or form I would like to create for each record. I read somewhere that the mail merge function within Writer can do this, but I could not make it work for some reason. Any advice greatly appreciated. Also, the info in the attached documents is garbage data I made up as an example.
Desired_Example_Report.odf (21.4 KB)
Example_b.odb (6.4 KB)

Report wizard

  1. All fields
  2. Single column layout
  3. Portrait orientation, modify report

In report design, click the details section and define “new page before and after”
Example_c.odb (13.2 KB)

1 Like

Indeed perfectly doable using Writer and mailing function.
Using your odb file this is what I endup with as template for a merge
and an example of the result. I am putting the base document to merge as example and I will add answers for two result pages.
:slightly_smiling_face:
Desired_Example_Report_Solution.odt (27.4 KB)

Result page 01
ResultForms_1.odt (23.1 KB)

Result page 02
ResultForms_2.odt (23.1 KB)

I actually feel a little bit foolish after stumbling across the workable solution on my own. I left mouse clicked on the table, and then I clicked on the Forum Wizard and followed the prompts. I guess I must have been kinda tired when I tried to do this late last night, and I kept hurrying through the steps without thinking about what I was doing. Anyway, I now have a form that is good enough for my needs, and I included a pdf of a single page in case anyone else has trouble in the future. Thanks again to everyone who took the time to answer my post.
Example_Form.pdf (11.3 KB)