Sales Report That Includes Items Not Sold

Has anyone seen or created a sales report (grouped by item - one line per item) with total sales, qty sold, quantity on order and the primary supplier's reorder #? I need the result to include all items in the item list even if they weren't sold within the user selected date sold range. We are trying to create a single report that uses sales history, current inventory position (on hand and on order) to better manage the inventory but we need to see all items not just items that have sold.