Regarding smartforms printing total of each page

[Former Member]

Hai,

I need ur help in printing smartforms,

my requirement is to print the total of line items at the end of each page in a smartform.

i know to print the grand total at the end of total line items,

how can i print the sum at each page end.

waiting for ur reply...

thanks in advance

[Former Member]

Hi,

In the global definitions declare tot type vbap-netwr

once when u create the table for line items, in that declare NETWR field also..

Then in the calculations tab

select operation-> total

fieldname-> w_vbap-netwr or if ur using intetrnal table

itab-netwr

target fieldname: tot

Along with this in the table you will get footer in that footer output options you will have two options select both of them.

1) at page break

2) at end of table.

now create a table line and under that create text element under the footer node and provide the variabl tot in that text element that data.

Thanks,

NN.

Thanks,

Nethaji.

[Former Member]

Hello,

All you have to do is, in the footer you do the calculations and print the values in the footer. i.e. in the table node we have the header main area and footer, so in main area you add the varaible and in the footer you pass the variable, please do make sure that in the footer options(double click on footer) you checkmark both the check boxes.

Check this out it will work

[Former Member]

I have the same but a little different problem.

my problem is that i required total on every page which is suppose to be the running total, i am using table in the main i am adding values and in the footer i am printing the total value and i checked both the options

at page break and at the end of table both.

Now the problem is that the first record on the next page is adding to the subtotal of last page record .

what is the possible cause of error??

[Former Member]

Hi,

i m not clear with u r question,

u need total per every page or u need complete total and it should print in every page.

i m explaining u two procedures.

Declare footer window in u r form,

Declare a variable count type i in the Global Definations,

Now count u r line items that fit in u r page,

if u r printing 20 line items in the page then make the footer window conditional i.e.

Double click on footer window ---> condition Tab

in condition tab -

---

> count = 20 .

Then the window will call for every 20 record and on every page.

If u need total of every thing and it should display every page,

then maintain main window size upto footer,

don't make any conditional to the footer,

then it will call in every page.

with Regards,

Kiran.G

[Former Member]

hi

In the global definitions declare tot type vbap-netwr

once when u create the table for line items, in that declare NETWR field also..

Then in the calculations tab

select operation-> total

fieldname-> w_vbap-netwr or if ur using intetrnal table

itab-netwr

target fieldname: tot

time :after loop.

when use command node after the table then pages will trigger and in each page the line items and their total will b displayed.

thnx

sravani

Plz reward if useful