Thanks Yuanitta,

It is the second case I was looking for, standard reports. I will play with subclassing the data engine.

Jack

>Hi Jack,
>
>If this prefilter is used for custom reports all you have to do is put your additional filter criteria into the STDFilter field of the reports table. If you are wanting to force a standard filter for a specific table with quick reports - try subclassing the SFDataEngineVFP(if that's the data engine you are using). Working with your subclassed data engine in the CreateSqlSelect()- first start with a dodefault(), Second check the .oQuery.cSQLSelect property and see if it contains the specific table you are looking for. If your table exists, find the 'Where' clause and stuff your own custom filter just after the word 'Where'. You can find more information about the STDFilter and subclassing the SFDataEngine in the SFReports.chm file.
>
>Hope this helps.
>Yuanitta