Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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