This is a daily report of a Flour Mill, LAST DAY"S STOCK, shows the last days stock,  1st column show the name of the item, 2nd col, Quantity (in bags),  3rd col total weight of bags. i want to create a report exactly like this. 
 
4th & 5th col, TODAY"S STOCK, QTY , WEIGHT. 
6th & 7th col, TOTAL STOCK, QTY, WEIGHT, (TOTAL OF QTY+QTY, WEIGHT+WEIGHT) = total stock.
8th & 9th col,  SOLD FLOUR, QTY,WEIGHT,  (i don't know how to take out the sold stock from current stock) 
and the item field should display the item_name how ever it has no record to display like below. i m really confused.

                                                               

                		     LAST DAY'S STOCK                         TODAY'S STOCK		            TOTAL STOCK                       SOLD FROM STOCK             CURRENT STOCK


 	ITEM_NAME		QTY		WEIGHT(KG)	     QTY		WEIGHT(KG)	   	QTY		WEIGHT(KG)	QTY	         WEIGHT(KG)       QTY	     WEIGHT                
ABC FLOUR 20 KG		         88		    1760	     500		    10000		588		  11760		 404               8080           184         3680
ABC2 FLOUR 100 KG           	 31                 3100	      40		    4000                71                7100           --                --             71	      7100
ABC3 FLOUR 20 KG                213		    4260	    -----                 ------                213		   4260	         100               2000           113         2260                 
ABC4 FLOUR 20 KG
ABC5 FLOUR 20 KG