Kevin,
Thanks for your input. I really didn't want to have to output the entire database into other pre-manipulated tables, but it seemed to be the only solution. I placed all the calculations and data manipulation in FoxPro and set the report to simply display the data.
Thanks for the help.
________________________
Ben Santiago, MCP & A+
Programmer Analyst (SQL, FoxPro, VB, VB.Net, Java, HTML, ASP, JSP, VBS)
Eastern Suffolk BOCES - Student Data Services
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
-Rich Cook