‎2007 Apr 24 10:16 AM
Hi ,
i have created emp file report . it is of some three pages. i want to display the total of their salaries in each page and finally in the last page as grand total.
i think we can do it with ctrl break st ie sum.
But iam not getting for subtotal.
Pls suggest.
Regards,
Nasru
‎2007 Apr 24 10:21 AM
Hi,
U can do like follows :
Say, if u are using Employee code which is unique then u can do as follows :
LOOP AT ITAB. (Itab contains ur data)
AT END OF EMPCODE. (Make sure EMPCODE is ur first field and table is
sorted by it. This will give the subtotal for each
employee)
SUM.
ENDAT.
AT LAST. (This will give the grand total)
SUM.
ENDAT.
ENDLOOP.
Regards,
Himanshu
Message was edited by:
Himanshu Aggarwal
‎2007 Apr 24 10:21 AM
Hi,
U can do like follows :
Say, if u are using Employee code which is unique then u can do as follows :
LOOP AT ITAB. (Itab contains ur data)
AT END OF EMPCODE. (Make sure EMPCODE is ur first field and table is
sorted by it. This will give the subtotal for each
employee)
SUM.
ENDAT.
AT LAST. (This will give the grand total)
SUM.
ENDAT.
ENDLOOP.
Regards,
Himanshu
Message was edited by:
Himanshu Aggarwal
‎2007 Apr 24 10:38 AM