>New user says HELP! I am trying to set up a program to compile data and generate a report to count to totals multiple fields (race, sex, employee pay grade & job code), perhaps others as well, but don't know how to go about setting the darn thing up. I want to be able to set up a program to run against a 4000+ person database to do this. Any suggestions?
Normally report data should be collected in a cursor. If you have complicated report algorithm you have to code chain of Select-SQL or even SCAN modules. Be sure that Foxpro is the best data manipulator and if you have the data it could be reported.
Edward Pikman
Independent Consultant