cancel
Showing results for 
Search instead for 
Did you mean: 

subtotals in smartform

Former Member
0 Kudos

Hi Experts,

We are working on customer account statement. for that we are developing a smartform, in which it should display subtotals and grand total.

Here the subtotal is month wise. and all the totals of subtotal is the grand total.

How can we get the totals monthly? it should print the line items of one month and its subtotal, then line items of second month n its subtotal etc... finally the grand total.

Can someone plz help me.

Thanks in advance,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Mytri,

Same topic has been discussed in this thread:

Regards,

Chandra Sekhar

Answers (4)

Answers (4)

Former Member
0 Kudos

guys thanks a lot.......

thanks a lot...

former_member181995
Active Contributor
0 Kudos

Create program line in under table and do a loop on same table with at end of statement and get the sum value in one temp variable.

Former Member
0 Kudos

Hi mytri,

Regards,

Sravanthi

Former Member
0 Kudos

Hi ,

In your loop node / table node --> calculation tab --> give the details of the operaton , the field on which the totals have to be done and the target field name ( subtotal / total ) and time as after loop.

now use the variables subtotal and total in the text node to display.

dont forget to clear the subtotal after displaying....

create program lines after display of subtotal and in that use the statement

clear subtotal.

regards

padma

Former Member
0 Kudos

Hi ,

Mythiri asked regarding monthly wise total not page wise total,

Regards

jana

Edited by: Janardhan Reddy on Sep 16, 2008 3:55 PM