>I want to create a program that creates a report in a user friendly environment. like specifying the tables needed, the relation, etc and will automatically save that report.

Hmm, what about providing the user with some option to run the MODI REPO command? Of course the user would need to know a bit about VFP, but that way it would be able to create their own reports. Of course there are some drawbacks with this approach, but it may suit your needs.