Footer table and loop

[Former Member]

Hi,

Invoice Smartforms:

I create main window with an table with header and footer.

In this table they are a loop to the different billing item.

In this loop, i addition the price of the different billing item and i insert this total in each page in the footer.

-He addition the price of the different billing in the page and addition the price of the billing who break in the next page.

because the event of the footer is at page break.

How can i do for he calculate the price in the page (before the next billing item break in the next page)?

in my loop i have that : I need to detect break page in the loop.

var_montant = GS_IT_KOND_W-KWERT.
var_remise = var_remise2.

var_somme = var_somme + var_montant + var_remise.


if SFSY-PAGE = 1.
  var_somme_page1 = var_somme - GS_IT_KOND_W-KWERT + var_remise.
  endif.

In page 1: var_somme_page1 have the good price but i have different page in function of billing items.

Thanks for your help.

[Former Member · Accepted solution]

declare a variable for the sum for price etc.

say v_sum.

In the main area of the table, under a cell add a program lines.

In this add the code: v_sum = v_sum + wa-price (the work area field for price)

In the footer of the table display the v_sum.

after display add a program line and add the code:

clear v_sum.

In this way v_sum will contain sum or subtotal for that page only.

Modify the logic as per ur requirement.