Asp.net One design

Question

Hi

 

I had two views one is instinward view 2 nd instoutward view in that multiple drugs multiple institutes r entry stock sum(bqty) ,recptdate group by drugcode,rcptdate this and outward view sales sum(oqty),odate group by odate,drugcode what i want  in grid view one column first entry date drugcode ,sum(qty) second column outward for that stock is cooming ti same date column sum(oqty)  third columns batchqty-oqty sales time different dates they are entered in this total qty 100 after that date sales 20  100-20 =80 

 

next sales date oqty 20   80-20=60 like that values need to come next row bqty need comes ones only

not understand see this bellow type of report i want

 

Sl	Drugname	Date	Received Qty	Issued Qty	Balance Qty
1	Dextrose|Injection|5%|1x500ml- 26.2.1	01/11/2020	100		100
		05/11/2020		20	80
		06/11/2020		10	70
2	Albendazole|Tablet|400mg|1x10x10- 6.3.2	03/11/2020		6	15
		05/11/2020		1	14
		08/11/2020	20		34