How to page breaks after certain sub total

Avatar

Avatar
Level 1
johanOh
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
johanOh
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
View profile
johanOh
Level 1

25-03-2021

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

 

 

 

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Coach
MVP
radzmar
MVP

Likes

397 likes

Total Posts

2,687 posts

Correct reply

492 solutions
Top badges earned
Coach
Ignite 3
Ignite 1
Validate 1
Give Back 50
View profile

Avatar
Coach
MVP
radzmar
MVP

Likes

397 likes

Total Posts

2,687 posts

Correct reply

492 solutions
Top badges earned
Coach
Ignite 3
Ignite 1
Validate 1
Give Back 50
View profile
radzmar
MVP

07-04-2021

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