Well, you want to do it the wrong way, so I suggest that you do it the right way. Running reports from live data can give very strange results, since the data may change while the report runs. Especially if the reports takes a long time to run, changing data may really give you headaches. Running the reports from cursors means that you will run them from a snapshot of the data as it was when you started the report routine.

If you really want to shoot yourself in the foot, I can of course help you loading your gun. But I would rather give you a warning first.

>Thank you Tore!
>
>Do you have an answer to my question?
>
>
>>>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
>>
>>I suggest that you always run your reports from cursors, not directly from the tables.