I have a table of customers and I need to do a report(invoices) for each customer, where I show the customer's name, data, his/her consumption in the month and a graph showing his/her consumption in the twelve previous months. How to do That?
Navigate to http://www.hentzenwerke.com/samplechapters/zsamplechapters.htm and download the sample chapters for "MegaFox: 1002 Things You Wanted to Know About Extending VFP". Chapter 6 (which is one of the sample chapters) gives you information and code to generate graphs using the MsChart ActiveX control, MsGraph and Excel automation.
