>Has anyone tried creating a SQL query on the fly and sending to Crystal Reports and then printing the preformatted report from within your Fox program? Pointers or suggestions would be greatly appreciated.

I would not recommend doing it this way. If it can be done, Crystal will use ODBC to pull the data. This will be sloooooowwwwwww. Run the query in VFP and save the results to a Fox2x table. CR can then read that natively.