Hi,

I want to create a pie chart and display it in a report. Has anyone done anything like that?

The approach I thought off is rather clumsy:

1. Export data into a table.
2. Open it in Excel through automation.
3. Create a chart programatically.
4. Capture this chart in a bitmap.
5. Save the bitmap to disk.
6. Use the bitmap in my report.

The main problem with this is how do I turn it into a bitmap. I have previously used George Tasker's utility to turn screens into bitmaps, but that one may not be applicable as it is an excel spreadsheet we are dealing with. Also, I would rather that all this is done in the background, so the user does not see excel coming up.

Now, is this a reasonable approach? Anyone has a better idea? If this is the only way forward, how do I turn the chart into a bitmap?


Steven