Page Break Pivot Table - Excel Report

[#1]

Hello,

I have a pivot table with different CCAM's and other items like you can see in Annex I.

I would like to make a page break to each CCAM (itens in green).

I've tried two ways.

First one - Press the "CCAM Field Settings" - clicking "Insert page break after each item".Doesn't works. You can see the result in Annex II .

Second One - With the Page Level in NPrinting. Doesn't work because the report only show one CCAM. You can see the result in Annex III .

Someone have other idea?

Thank very much

[Daniel_Jenkins]

Hi Ana,

Your first way: Insert page break after each item works for me. Of course your preview needs to be in the Page Break Preview view to see the page breaks.

Or you could Save As to PDF or actually print the document.

HTH - Daniel.