Expand my Community achievements bar.

How to page breaks after certain sub total

Avatar

Level 1

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:

 

johanOh_5-1616726361276.png

 

 

To-be:

johanOh_6-1616726429696.png

 

 

johanOh_7-1616726474240.png

 

 

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)

 

johanOh_8-1616726715503.png

 

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

 

Many thanks,

 

Johan

 

 

 

6 Replies

Avatar

Employee
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.

Avatar

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

Avatar

Employee
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

Avatar

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

Avatar

Level 10

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