solved, spent way too long on this and it was such a small thing!!!I have put the carryforward subform inside the header subform, and set the header subform as the overflow leader. I also made the carryforward subform hidden if on the first page! Thanks for your help on this episode Paul.

Ok i have figured out the calculations and I am getting exactly what i expect now.I still have 1 remaining problem to (it is do with pagination settings)............I need to have each page displayed in the following way.subform headersubform carryforwardsubform sf1subform footersubform totalsf1at t...

meh i hate being a nuissance! but we still having a problem:, page 3 is wrong

Hi Paul thanks for your help again,the calculation for the "Footer" subform is still incorrect. It totals incorrectly, it should add all fields in AmountPaid + Carryforward field. For example page two of the document should have the page total value of 8218, and page 3 of the document should have a ...

Hello Paul,Than you very much for your help on this, I thought I had it all complete but my boss wants a new feature added that Im not sure about. I hope you can help once again.At the moment the document shows a subtotal on each page and a grand total on the last page, I have been asked into implem...

I think I have found a solution:varoDB = xfa.sourceSet.nodes.item(nIndex);oDB.open();if(oDB.isEOF()){oDB.close();}else{oDB.first();...............rest of code.......................................oDB.close();}It works for me, but can anyone foresee a problem with this implementation?

Hello Paul,I have 1 problem with my code for initialise in form1. If there is no data in my database i get the following error:GeneralError: Operation failed.XFAObject.first:12:XFA:form1[0]:initializefirst operation failed.  There are no records in the datasource.I think the problem lies here on lin...

Perfect Paul !!Thank you very much for this,I see you added a new subform and the following code: How does the subform "understand" that it should show on every page instead of at the end of the previous subform?This part here?I cant see any other code additions, am i missing somewhere?

Its ok whenever you get a chance, would be nice to get a good example

Honestly I would like it in a flowed format and change the sturcture to include a footer if its not too much trouble to build, im sure ive seen a few people asking about this example on the internet but nobody seems to know how to do it. Otherwise if it will take long too make then if you show me th...