How can I insert page breaks in a pivot table?

[fhchap]

I have a pivot table in which there is a subtotal after each item. Then I have a blank line between items. The screen shot below illustrates.

This table could grow to hundreds of items and I need to be able to print each on a separate page. In other words, using my screenshot below, James woods would be printed on page 1, Jane Doe on page two, etc. In Excel there is a way to do this simply by clicking “Print Each Item” on a separate page. Is there a way in LibreOffice Calc to do this? I am running the latest 6.2 release

[Hrbrgr]

Select the cells you want to print. Select File>Print from the menu. In the dialog box, select “Selected cells”.

Other possibilities are described here.

If my answer has solved your problem, please click on the checkmark ✓ in the circle to the left of the answer and click on the arrow ^ for upvote. This will tell the community that the question has been answered correctly.

[Hrbrgr]

With me Windows 10 Home; Version 1903; 64-Bit | LibreOffice, Version: 6.2.5.2 (x64).

[fhchap]

Thank you for your response. The problem is that I need to be able to generate individual reports (one for each item. The actual report could be several hundred pages. thus it would be very time consuming to go through and set a print area. for each report. To compound the issue, it needs to be dynamic. Excel solves this with a single setting in the Pivot Report. I am assuming LibreOffice does not have something similar.

Perhaps there is a macro that could automatically insert a break after each item subtotal.