line level detail across all order statuses

I need a database style report containing line-level detail (e.g., items and quantities) across all statuses—including Ordering.  This is extremely important to our business and will need to consider an alternative WMS if creating a report like this is not feasible.