How do I make a report in libreoffice base showing multiple values for one field per page?

[ralf.kof]

I have 2 tables:

Table 1 lists names:
Ex.
LastName FirstName
Doe John
Hancock John

Table 2 lists phone numbers for each name in table 1:
Mr. Doe has 2 phone numbers
Mr. Hancock has 2 phone numbers

I want to create a report showing one entry from table 1 listing all his phone numbers in just one page.

The end result would be two pages. One containing Mr. Doe’s phone numbers the other, Mr. Hancock’s.

I’ve succeeded in grouping them, but I can’t seem to separate them per page.

[Hrbrgr]

https://documentation.libreoffice.org/en/english-documentation/

[Ratslinger]

Hello,

Since you already have discovered grouping, when editing the report you can set the property for page breaks:

Select the Header section and then display the Properties. Force New Page is the affected property.

[ralf.kof]

Thank you for the reply… I was using force new page “after section” and it wasn’t working. It never occurred to me use “before section”. “Before Section” option was applied to the grouping header. I got the desired results. Thank you so much.