>>BeforeOpenTables() method seems to be a good place for that.<
>
>Am I safe in assuming in this situation that I don't need to return SET DELETED to its initial state in this situation in a report?
>

Don't worry, it's scoped to the current datasession.