[IMP]Improved query to fix that pos datas is not availabel in report