Our Transaction without documents report is no longer working since upgrade

This report was possible before the upgrade because the ADM and Document and Focalpoint and Dimensions databases were on the same server on Premise.
​
As you're now hosted the Focalpoint, ADM, and Document databases don't have sight of each other as they're on completely separate servers. As such they can't be linked to provide the detail the report needs.