Swen,
Are you setting the filter from a Private Datasession form before doing the report? Also why not just build a temp cursor for the report? You can use the same condition of the FILTER in the WHERE clause.
>VFP 5.0 SP3/Win 95/NT Network
>I have a transactional table with an EventDate column defined as DateTime and some informational columns. There is regular index defined on the EventDate column.
>
>I have a report where the user specifies a first and last date. I filter using
>"SET FILTER TO BETWEEN(TTOD(EVENTDATE),LLODATE,LHIDATE)".
>
>There are 2 events at the top of the file with the same datetime. The report will show these both sometimes but page-down, page-back will make the first one disappear. My guess is that the index is not distinguishing between these rows.
>
>Any help in making this more consistant will be greatly appreciated. Thanks