Do all the fields exist AND IN THE SAME ORDER on both you machine and the clients?
>Crystal is throwing an error:
>
>"One or more fields could not be found in the result set. Use Verify Database to update the report"
>
>
>I have verified the database and I still get it.
>
>The report previews fine in Crystal, but when run from the client, it errors.
>
>The query string being passed to SQL from Crystal is identical to the query being
>passed from the VFP dialog.
>
>I could use some help here.
>
>Thanks
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer