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
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies