>3. We built the Report Designer into our application because we wanted a close tie with our internal query builder. As a result, end users, etc. can create their own reports with the functionality of the FoxPro report writer. I wonder if its possible to include the Crystal Reports designer into your EXE? Or for that matter, has anyone had any experience with any of the commercially available report desigers that you can include in your EXE...recommendations?

Yua can embed open source fyireporting.com report designer and engine.
It uses same RDL format.
I created small routine to use it from appl like VFP report designer.