on 09-08-2008 11:50 AM
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
guys thanks a lot.......
thanks a lot...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.