cancel
Showing results for 
Search instead for 
Did you mean: 

Smartform - Subtotal on each page - Reset on new page

Former Member
0 Kudos

Hi Experts,

I am using table calculation tab to calculate my subtotal.

I want to rest this subtotal to zero for every new page. I want page wise subtotal.

Can anyone suggest how do I go about it. I have included a program lines and checked for a change in the page number and tried to clear the subtotal. But it does not work.



 if page ne sfsy-page.
  clear: subdebit, subcredit.
  page = sfsy-page.
endif.

The first line of the second page is getting missed out in the subtotal.

Regards,

Abdullah

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Calculate subtotal by placing program lines node in Table after displaying the Line items. Display the subtotal field in Footer Node of table. It automatically reset for every new page.

If it is not working then try with Sort of Begin and Sort of end events which are available in Table node.

Clear Subtotal field value in Sort of begin node and display the Subtotal in Sort of End node. It is working just like Control break statement in Reports.

former_member246728
Participant
0 Kudos

I have got the same problem could you tell me how it is solved ?