Hi!

I have a freetable called 'cperformance.dbf'' which contain field
gname,fname,collection.

I have this in a form with a grid, displaying ' Fname, Gname,Collection'.
This freetable display the staff collection performance
in numbers but it would also be very nice to display the figure in Graph?

Anybody, can share me your sample code of creating a GRAPH and print them?

Any assistance is very much appreciated.

/patrick

Re: MS Graph by Big

Big
Thu Mar 13 15:14:32 CDT 2008

Patrick:

If you look in your VFP samples directory you will find two forms showing
how to work with graphs, graphrec and olegraph. look in the
samples\solutions\ffc folder and the samples\solutions\ole.

Both forms are good eamples.

BR
"Patrick Tura" <patrick@kff.ph> wrote in message
news:F67D4205-1847-4C24-B39D-4ABC9D82699F@microsoft.com...
> Hi!
>
> I have a freetable called 'cperformance.dbf'' which contain field
> gname,fname,collection.
>
> I have this in a form with a grid, displaying ' Fname, Gname,Collection'.
> This freetable display the staff collection performance
> in numbers but it would also be very nice to display the figure in Graph?
>
> Anybody, can share me your sample code of creating a GRAPH and print them?
>
> Any assistance is very much appreciated.
>
> /patrick



Re: MS Graph by Mike

Mike
Fri Mar 14 14:38:04 CDT 2008

Here are some notes I have embedded in a Visual Foxpro program I have
created.


Creating Graph Using MS Graph
**********************************************************************
** Create a Table(Cursor)with a general field (ie OleGph).
**
** Create a OLE control on a Form (ie oleMsGph).
**
** Create a string (cGphHdr) with the field headings followed by
** a tab. The final field is followed by a carriage-return and not a tab.
**
** cTab = Chr(9)
** cCr = Chr(13)+Chr(10)
** cGphHdr = ''
** cGphHdr = 'FieldA'+cTab+'FieldB'+cTab+'FieldC'+cCr
**
** Create a string (cGphDta) with the data to be graphed. Each
** field is seperated by a tab, except for the final field,
** which is seperated by a carriage-return.
**
** cGphDta = ''
** cGphDta = cGphDta +;
** FieldA+cTab+FieldB+cTab+FieldC+cCr
**
** Create a title string for the graph if one is desired.
**
** cGphTitle = 'My Title'
** ThisForm.oleMsGph.HasTitle = .T.
** ThisForm.oleMsGph.ChartTitle.Caption = cGphTitle
**
** Append the graph header (cGphHdr) and data strings (cGphDta)
** to the control on the form. In Version 5, this statement
** must appear twice.
**
** APPEND GENERAL GphCsr.OleGph DATA cGphHdr + cGphDta
** [APPEND GENERAL GphCsr.OleGph DATA cGphHdr + cGphDta]
** FLUSH
**
** MS Graph can be called within Foxpro via:
** Thisform.oleMsGph.DoVerb(-1)
** ThisForm.oleMsGph.DoVerb(-2)
**
**********************************************************************






"Patrick Tura" <patrick@kff.ph> wrote in message
news:F67D4205-1847-4C24-B39D-4ABC9D82699F@microsoft.com...
> Hi!
>
> I have a freetable called 'cperformance.dbf'' which contain field
> gname,fname,collection.
>
> I have this in a form with a grid, displaying ' Fname, Gname,Collection'.
> This freetable display the staff collection performance
> in numbers but it would also be very nice to display the figure in Graph?
>
> Anybody, can share me your sample code of creating a GRAPH and print them?
>
> Any assistance is very much appreciated.
>
> /patrick



Re: MS Graph by Paul

Paul
Fri Mar 14 17:56:10 CDT 2008

"Patrick Tura" <patrick@kff.ph> wrote in
news:F67D4205-1847-4C24-B39D-4ABC9D82699F@microsoft.com:

> Hi!
>
> I have a freetable called 'cperformance.dbf'' which contain field
> gname,fname,collection.
>
> I have this in a form with a grid, displaying ' Fname,
> Gname,Collection'. This freetable display the staff collection
> performance in numbers but it would also be very nice to display the
> figure in Graph?
>
> Anybody, can share me your sample code of creating a GRAPH and print
> them?
>

If you still have no luck in graphing your data, there is a simple to use
graphing utility on our website http://www.abri.com

-----------------------------------------------------------------
Paul Lee ........ Abri Technologies ........ http://www.abri.com/
'Recover' - top rated FoxPro file repair utility.
-----------------------------------------------------------------

Re: MS Graph by Patrick

Patrick
Fri Mar 14 22:08:15 CDT 2008

thanks a lot big bubba.

I'll look around.

/patrick
"Big Bubba" <spamhere@aol.com> wrote in message
news:5YSdnd4Xisa1FkTanZ2dnUVZ_r2nnZ2d@rcn.net...
> Patrick:
>
> If you look in your VFP samples directory you will find two forms showing
> how to work with graphs, graphrec and olegraph. look in the
> samples\solutions\ffc folder and the samples\solutions\ole.
>
> Both forms are good eamples.
>
> BR
> "Patrick Tura" <patrick@kff.ph> wrote in message
> news:F67D4205-1847-4C24-B39D-4ABC9D82699F@microsoft.com...
>> Hi!
>>
>> I have a freetable called 'cperformance.dbf'' which contain field
>> gname,fname,collection.
>>
>> I have this in a form with a grid, displaying ' Fname, Gname,Collection'.
>> This freetable display the staff collection performance
>> in numbers but it would also be very nice to display the figure in Graph?
>>
>> Anybody, can share me your sample code of creating a GRAPH and print
>> them?
>>
>> Any assistance is very much appreciated.
>>
>> /patrick
>
>


Re: MS Graph by Patrick

Patrick
Mon Mar 17 08:35:52 CDT 2008

Guys, Mike and Paul,

Thank you very much for your assistance. That is what I love in this
newsgroup, you will sooner or later find a solution to your problem.

Those information, will surely help me create MSGraph.

/patrick


"Patrick Tura" <patrick@kff.ph> wrote in message
news:F67D4205-1847-4C24-B39D-4ABC9D82699F@microsoft.com...
> Hi!
>
> I have a freetable called 'cperformance.dbf'' which contain field
> gname,fname,collection.
>
> I have this in a form with a grid, displaying ' Fname, Gname,Collection'.
> This freetable display the staff collection performance
> in numbers but it would also be very nice to display the figure in Graph?
>
> Anybody, can share me your sample code of creating a GRAPH and print them?
>
> Any assistance is very much appreciated.
>
> /patrick