>I have a single view in the data environment for a report. I want to have a private data session I need to set deleted on somewhere in this datasession so that it will not look at the deleted records. I put set deleted on in the init method of the datasession. Then when I preview the report, the first time it will show the deleted records, but if I close it and preview it again, the deleted records no longer show up. Any ideas?
Put your SET DELETED in the report's data environment's BeforeOpenTables event.