General information
Category:
Reports & Report designer
Steven,
You might want to look at MS Office Web Components(OWC). This is a free tool from Microsoft. I believe it comes with MS Office or you can download it.
I use it to generate charts and graphs on our website on-the-fly. It is very fast and easy to use. West-Wind.com even has a class library that uses OWC.
Basically you can create your cursor to graph, set properties in OWC for chart type, colors, etc..., and OWC will chart the data and generate a .GIF in a location you specify.
Perhaps you could use this for creating a chart on your VFP report.
Thanks,
Jerry
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only