Fernando,

I use this view as data source:

select DAKTE.Datum, DAKTE.Vorfrist, DAKTE.BearbDurch, DAKTE.AK_ID, DAKTE.TermArt, DAKTE.Bemerkung, DFRA.Bezeich ;
FROM URANUS!DAKTE ;
JOIN URANUS!DFRA ON DFRA.ID=DAKTE.TermArt ;
WHERE DAKTE.Erl=.T. AND DAKTE.Erl2!=.T. ;
ORDER BY DAKTE.AK_ID, DAKTE.Datum

Iwill try your suggestion and report back on Wednesday.

Gerhard


>>Hi Fernando,
>>
>>Thank you for your answer. My description of my problem was not that exhaustive, sorry. Your tipp is working in the developement environtment, but I need to change the settinghs in an EXE. Do you know a trick to do it there too?
>>
>>Gerhard
>
>Gerhard, isn't more easy to add "AND NOT DELETED()" in the "WHERE" clause?
>
>The complex situation here is that it is not clear HOW you use the tables in the dataenvironment that you have trouble with the report.
>
>May be you can expand with more details on your report and the tables in the dataenvironment and the like.