You should be able to change the query dynamically.
As a different option, you can do all the queries in VFP, store the results in Fox2x tables on disk, then have Crystal use those for the report.
Or..
You can pass an ADO Recordset from Fox directly to Crystal.
>What if you need to add a new filter field (which you havent already put in crystal designer), dont you have to add it in crystal as well?. Thats what I want to avoid. To refrase my question, is it possible to change the query dynamically or you always have to go throu parameters ?
>
>Thank you very much for your help.
>
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer