I will sure create a template report for future use. For old reports it seems I have to bite the bullet.

Thanks again for your help.

Gerhardhttps://www.levelextreme.com/Images/MenuRefresh.gif

>>Customers can create reports and did so. I would like to change the settings in reports of customers without getting them to my office and sending them back after the change.
>>
>>Gerhard
>>
>>
>>>>>Gerhard,
>>>>>
>>>>>the Init event 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.
>>>>
>>>>Hello Lutz,
>>>>
>>>>Thank you!
>>>>I moved SET DELETED ON to the BeforeOpenTables of the DE of the report. Now I can use a private datasession without problem.
>>>>
>>>>But :-))) :
>>>>This is only possible in the Developement environment. I can not set this in the runtime environment. Is there a way to change this setting in runtime?
>>>>
>>>>Gerhard
>>>
>>>I do not understand
>>>
>>>If you put the code in the DE OPEN_TABLE it should run at runtime? Just put it in and leave it there by default? Whether or not in Private DE ...
>
>Let them create the report from a template, and the template holds the code required. IOW on "New report" create a copy from the template and open that. It's wise to not let them onto the code snippets. This is a big door for harm. The code there could manipulate each and everything as far as customers access rights work. Shiver.