>I have created 2 reports that work great, except I have entered
> "LEN(ALLTRIM(Seeking)) > 0"
>in the datasession filter property.
>
>This gives the results I want in the reports, but after the reports have run, the filter is not reset. I tried putting a "SET FILTER TO" in the destroy property, but no luck.
>
>How do I release the filter?
>
>TIA
>Bill Broyles
Simply you don't put a filter there nor use dataenvironment of report's dataenvironment. Instead you do a select prior to reporting and get the records you want to report on into a cursor and run your report (report fields do not have aliases for the most flexibility except any related tables' fields if any).
Cetin