calculating demo out date for same item id and serial number.

hi,

I am working on Inventory module and have to create new report in which I have to calculate number of days for item which is out for demo.

Item Id and serial number is same and same Item goes for many times and came back, having enum Inward & Outward.how to separate each item whose is still out.

thanks n regard,

sanjay thakur