BeforeOpenTables() method seems to be a good place for that.

>I usually don't use the DE in a Report.frx and use a Private Data session - which leads to this question about SET DELETED ON.
>
>I have a report that has a local view in the DE as it source (and Private Data Session is on). When the report is previewed - deleted records appear. Can someone tell me the normal way and where to SET DELETED ON for this report so that deleted records are ignored in this situation.
>
>Mel Cummings