Hello,

I'm rather new to foxpro, although i've done quite a bit of database development in the past using oracle, sql server, and informix. I'm finding vfp to be quite a bit different, and honestly a bit frustrating. I'm trying to just run a query and generate a report. After fooling with this for several days, sqlplus doesn't seem so bad!

So, I finally managed to come up with .qpr file that does what I want, in terms of generating the right rows and columns. Now, I want to have this dumped into a report, although just being able to get it into excel would be totally acceptable, maybe even preferable. The trick is that the management folks should be able to do this on their own once i'm done. With Oracle, i've shown folks how to open excel, and use an odbc data source to run a query and grab the data they need. Is there some way to do this with vfp? That would be ideal, I think. I was thinking I could write some sort of class or procedure that you could double click on that would open the table, run the query, and dump the results into a report, but the mechanics of that so far are beyong my expertise. The documentation on all of this always seems to assume that you are writing some sort of monolithic app and you want to add a report to it. I just want some data; Whats the best way to do this?

thanks very much for any input you might have
noah