The filtering is applied as part of the SQL query that is passed to the VFP OLEDB provider, so VFP is doing the filtering.
>Thanks for your replay. I know this technique, but my intension is not to use any filters in crystal at all, but these to desided in vfp. The query in crystal should be defined only to have the fields to use them in the designer. Any filtering should be done in VFP, and will be dynamic, meaning the filter fields wont be known at design time.
>
>dim.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer