Assist Allan Modino on there are no output generate for the Per Loc Inventory Report by Sub-dept, tried generating the report but got the same result. Check the actual report in the report designer and tried to generate to see the actual error. The error was avg_cost is ambiguous as per checking in the stored procedure the avg cost was pointed to inventory but there was also an average cost in the product dim. Report my findings for his checking as per Eli the report didn't know where to fetch the avg if it's in inventory or in product_dim. This is now ok as per Eli and I successfully generated the report. Emailed the generate report to Allan for his checking.