>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?
>Thanks.
For the graph part, you might use MS-Graph (I have no experience with that), or automate Excel. Here I do have experience, but I didn't work much with graphics. However, the simplest option seems to me to have a template with the required graphs ready-made, and simply fill in the required data fields.
If the range is a variable size, you may have to automate the creation of the graph itself.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
