Constraint violation when viewing Mailing Detail Report (group_id the cause)
Turned out to be a filter value in the report that was referencing a mailing group that no longer exists. It's 'id' was therefore missing from the civicrm_group table.