Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Graphs in reports?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00925468
Message ID:
00925590
Vues:
14
Thanks! Now you're teasing me! The "CLASS" verbage in the append general is new to me - and I am gonna chase that dude down (as he clumsily reveals the narrowness of his scope and experience:0). BTW: I like MS Chart!

The original post - if I remember correctly - asked about an Excel Chart. VFP-EXCEL automation can isolate and copy an Excel Chart area to the clipboard. The question then becomes: How to get that Excel Chart in the Clipboard to a report?

An MS CHart Object - from what I remember- moves well inside the VFP environment. But the Excel Chart is in the clipboard. It's cached, neither object nor class (i think). How to make the clipboard contents into an object (any kind of entidy) that VFP can manipulate is the 2$ question!:-)

>Terry, you don't need it to be in the clipboard at all.
>
>That's your problem resolving this -- I mean it's why you are having so much trouble envisioning the proper solution. You're dragging in emulation of user interaction to perform a programmatic function, in a way that is just not needed <s>.
>
>Sample code, let's see.
>
>First, a short thing you can do in the command window for an illustration:
>
>
>
>cData = "3" + CHR(9) + "5"
>cData = cData + CHR(13) + CHR(10) + ;
>        "1" + CHR(9) + "5"
>
>CREATE CURSOR x (onefield g)
>APPEND BLANK
>APPEND GENERAL x.Onefield CLASS ;
>   "msgraph.chart" DATA cData
>
>CREATE FORM c:\temp\x
>* put an oleboundcontrol in the form.
>* bind it to x.Onefield.
>
>DO FORM c:\temp\x.scx
>
>
>
>OK so far?
>
>Do you need the code that actually uses this during a report run, or can you envision from here? Basically you stick some code in report OnEntry and/or OnExit events to affect the contents of x.Onefield as you go.
>
>If I remember correctly you have to GO RECNO() IN x to get the graph in the form to refresh so that the report entry refreshes as you go through the records.
>
>There is nothing interactive, and no clipboard use. And you don't *show* the form, remember, you just use the binding to change the properties of the graph object.
>
>You can get the appropriate graph object object model from a really obscure CHM file, also delivered with office. In my current version I think it's called VBAGR10.CHM.
>
>HTH,
>
>>L<
Imagination is more important than knowledge
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform