Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Graphs in reports?
Message
From
17/07/2004 16:08:18
Steven Edge
Soft Solutions Limited
Lagos, Nigeria
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00925468
Message ID:
00925498
Views:
16
OK. I got it to work with Microsoft Graph by playing around a bit.

I put Microsoft Graph in a general field, and passed values to it.

Thanks a lot.

Steven


>>>The main problem with this is how do I turn it into a bitmap
>
>You can do this by putting an OLE general field instance in a form, referencing the form in a UDF called by the report bands, and poking values into the general field's graph (or chart) as you go through the detail instances. You don't really need a file to exist anywhere, IOW.
>
>But you can turn an Excel chart or graph into a bitmap too, if you want, without seeing Excel.
>
>The basic method is something like this:
>
>* -- design a template XLS with the graph you need
>
>* -- automate Excel to poke the appropriate values in (user does *not* have to see this)
>
>* -- tell Excel to SaveAs type HTML
>
>* -- grab the resulting image(s) which are always named and positioned according to a specific pattern with respect to the file path and name of the HTML file
>
>* -- rename and re-position the image file(s) as you want them.
>
>In VFP 9, of course, you have other possibilities that don't involve MS Chart or Excel at all <g>.
>
>>L<
Previous
Reply
Map
View

Click here to load this message in the networking platform