>Thanks to all that participated so far.
>I was to busy yesterday to write here.
>
>I think I should start from scratch again and give a useful description of my problem.
>
>I have a table with some deleted records. The data needed for a report are selected in a view that is saved in a DBC.
>In the report the view is referenced in the DE.
>The report is started from a "report manager" form with a button, that runs some code to prepare the environment for my report and finally runs the report with this code:
>
> PRINTJOB
>WAIT WINDOW "SET DELETED ON in ReportSetup"
>SET DELETED ON
> IF EMPTY(slcHeading)
> REPORT FORM (ThisForm.cPrintName) NOCONSOLE TO PRINTER &slcOpts
> ELSE
> REPORT FORM (ThisForm.cPrintName) HEADING slcHeading NOCONSOLE TO PRINTER &slcOpts
> ENDIF
> ENDPRINTJOB
>
>WAIT WINDOW and SET DELETED ON are added for test purposes.
>
>I also added SET DELETED ON in the INIT of the DE of the report for test purposes.
>
>The report works perfect until I switch on PRIVATE DATASESSION. Then and only then deleted records are included in the report.
>
>To me it is quite obvious that settings (SET DELETED ON) are not in effect in the private data session. Am I wrong here? If not: How do I set my settings for the private datasession?
>
>TIA
>Gerhard
>
>
>>Happy New Year!
>>
>>I want to set some values like SET DELTED OFF for a Private Data Session of a report.
>>
>>Where can I do this?
>>
>>TIA
>>Gerhard

Gerhard,

the Init ecent is to late. The data is open there. The OPEN_TABLES ist the event where you should place your code.

Note also that a SQL SELECT (a view is one) on SET DELETED OFF will get all records, even the deleted ones as non deleted. IOW a record marked as deleted on the source will becom not deleted on the result.

Posibly you might run a REQUERY against your view in INIT like

SET DELETED ON
REQUERY()

This will not work if the view is cascaded.