cancel
Showing results for 
Search instead for 
Did you mean: 

How to create subtotal in every invoice page for print layout design

Former Member
0 Kudos

Dear Experts,

How can I create subtotal column for every page if having more than one page of items in my invoice?

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Rachel......

You can obviously do it.

You have to Apply ColSum('F_No.') Formula and put this on Page Footer Area...

This will display the Subtotal on each page.......

Regards,

Rahul

Former Member
0 Kudos

You can do it.

You have to Apply ColSum('F_No.') Formula and put this on Page Footer Area

This will display the Subtotal on each page.

Thanks

Manvendra Singh Niranjan

Answers (2)

Answers (2)

kvbalakumar
Active Contributor
0 Kudos

Hi Rachel,

Try this

1. Create a formula with Colsum(Field) in the Repetitive Footer area.

2. In Repetitive footer area properties, General tab --> Flag the Display Repetitve Area footer in all pages option.

Regards,

Bala

Former Member
0 Kudos

Hi,

It works, but the sub total keep accumulating for pages before. and the subtotal for the last page is the equal to the grand total already. How do I control to just have the subtotal for every single page?

Please help. Thanks!

Former Member
0 Kudos

Hi Rachel Lau,

You have to doit by using Formula.

You have to create Formula Field & put feild which calculate for subtotal.

Thanks,

Srujal Patel