A self-hosted reporting tool should let authors create and maintain reports, and let authorized readers find, filter and use them in a browser. Start with the decision the report supports. For dispatch, that’s deciding which late orders to chase first and who should follow up.
Use one row per order. Include orders that are still open after their promised dispatch date, and show the order number, promised date, branch and assigned team. Agree which time zone and cutoff apply so two readers can reconcile what they see.