In Sales Invoice user update same stock code few times
When preview report, user wants to display the total QTY for same item
Solution :
Step 1 : In Report Designer à Right Click Detail 1 à Group Footer
Step 2: GroupFooter1 is created
Step 3 : Move all items in Detail1 to groupFooter 1
Step 4 : Delete the QTY field and drag again
Ste p 5 : In QTY à Summary à Select Group
Step 6: when preview you will get result as below
Note : If you get result as below, please follow step number 4
Please refer attachment