Your best bet is to take the results of your SQL query and use the COPY TO ... TYPE FOX2X command to save the result to a temporary table. You can then use the Crystal Reports xbase driver to retrieve this data and display it in a Crystal Reports report.
Like other people on here, I've found this to be the best way to combine the two products. You get to use you Foxpro skills and the power of the Foxpro data engine to generate the data, and the power of the Crystal Reports report writer to present the results to the users.

Randy