Might I suggest looking into purchasing Cathy Pountney's book The Visual FoxPro Report Writer: Pushing it to the Limit and Beyond available at:
http://www.hentzenwerke.com/catalogpricelists/vfprw.htmThis is an excellent collection of information. I have referred to it numerous times and have never come away disappointed.
Chapter 10 deals with real life situations and I believe you can find your solution there.
Good luck.
