How to page breaks after certain sub total

[johanOh]

Hello experts,

I have a trouble in breaking page based on a certain field which is sub total highlighted in yellow. and after last sub total, it is required to show Total of all sub total.

Please see my followings:

As-is:

To-be:

For this To-be, I have set up conditional breaks as below but it is not working as expected, " C-LCurrMonthAnount " is the sub total field)

It would be really appreciated if you can advise me how to achieve this requirement.

Many thanks,

Johan

[Kosta_Prokopiu1]

you want each block to be on a different page, correct? If you can upload the XDP to goole drive or similar and PM me the URL, I will have a look. Your form is too complex for us to guess what the solution could be.

[johanOh]

https://drive.google.com/drive/folders/1EhVrmgvXie45VbyogBqpPh7SdICm_vAu?usp=sharing

[johanOh]

Hello Kosta, thanks for the heads up. you can refer to above link(google drive)

[Kosta_Prokopiu1]

could you also send me a sample xml data file which produces several blocks? Use personal message for the links unless you ant them to be forever visible 🙂

[johanOh]

It is XML file that I have posted in the file located.

[radzmar]

You don't need a conditional break for subform "Table" but its nested subform "Periods". 

Just add this FormCalc script to create a page break for each except the last instance.

$.index lt Table._Periods.count - 1