There are quite a few options available for you to use. If you want native VFP then you could try FoxFire query and reporting.
http://www.micromegasystems.com
Another popular choice is Crystal Reports from Seagate. If you prefer to roll your own then you could use Doug Hennig's report objects class available from FoxTalk.