VFP 愛用者社區

[ericchuang]

最近在研究統計圖表的製作,一直在本站潛水搜尋適合的文件解決我目前的難題; 終於我在 http://www.ml-consult.co.uk/foxst-23.htm 這個網站找到了我要的一個解決方案; 現在, 我也野人獻曝一下, 這個vcx我個人覺得還滿不錯的! 分享給有需要的同好們! 若有版上先進已用過,是否也可以分享一下心得!
以下是此類別的說明文件(在類別內也有):
* Documentation for the class. Not intended to be executed.

* SimpleChart class. Written by Mike Lewis (Mike Lewis Consultants
* Ltd.), February - March 2002.

* Copyright Mike Lewis Consultants Ltd. All rights reserved.
* Feel free to use this class in any way you like, but please
* do not remove our copyright notice or the following disclaimer:

* Although we have tested this class thoroughly, we cannot accept
* any legal liability for its use. Do not use this class unless you
* are satisfied that it works correctly in your application.

* We welcome your feedback. Please email Mike Lewis at mikl@compuserve.com
* or see www.ml-consult.co.uk


* What does it do?

* The SimpleChart class produces two- and three-dimensional charts
* and graphs, using data from a Visual FoxPro table or cursor.


* What do I need?

* The class is based on Microsoft's MSChart ActiveX control
* (MSChrt20.Ocx), which comes with VFP 6.0 and 7.0. To use the
* class, you will need the ActiveX control to be installed on your
* own computer. To distribute applications which use the class,
* you will need to ensure that the OCX file is present and
* properly registered on the end-user's computer.


* How do I use it?

* The first step is to provide a table or cursor which contains
* the data required for your chart. Then drop the class on a VFP
* form, set certain properties, and finally call its CreateChart
* method.


* The cursor

* The chart is always populated with data from a cursor (or
* table). You can use an existing cursor if it already contains
* the required data, or you can create one specifically for this
* purpose.

* The cursor must have the following characteristics:

* - A record for each data point on the chart.

* - A field for each of the series on the chart. These fields must
* be numeric.

* - Optionally, a field containing the row label for the current
* record. This field must be a character string.

* As an example, suppose you wanted to plot monthly sales value
* and monthly sales quantity for the year to date. Your cursor might look
* something like this:

* MONTH_NAME SALES_VAL SALES_QTY
* JAN 4000 32
* FEB 4020 33
* MAR 4090 36
* APR 4070 34

* This will produce a chart with two lines and four
* data points. The horizotal axis will show the four month names
* as labels.


* Minimum properties

* Once you have dropped the SimpleChart control onto a VFP form,
* you must set certain properties. You can do this either in the
* Form Designer or in code (for example, in the control's Init
* event).

* The following are the key properties that you must set:

* cAlias The alias of the cursor (or table) containing the
* data to be plotted.
*
* cData A comma-delimited list of the fields within the
* cusor which contain the actual data.

* In addition, you will probably want to set one or both of the
* following properties:

* cRowLabels The name of the field within the cursor
* containing the row labels (these will appear
* along the x-axis).

* cLabels A comma-delimited list of the labels that are to
* appear in the legend (if any).

* To continue with the above example, the following code sets the
* required properties:

* WITH THIS
* .cAlias = "csrSales"
* .cData = "sales_val,sales_qty"
* .cRowLabels = "month_name"
* .cLabels = "Value,Quantity"
* ENDWITH


* Other properties

* The above properties are the only ones needed to create a
* default chart. However, the class also exposes many other
* properties that can be used to customise the chart in various
* ways. Some of the more important of these are listed below.

* The folowing are native properties of the MSChart control
* (further details can be found in the Help file for the control).


* BorderStyle The border for the entire chart (0 = no
* border, 1 = single line; default 0).

* ChartType 0=3D bar, 1=2D bar, 2=3D line, 3=2D line,
* 4=3D area, 5=2D area, 6=3D step, 7=2D step,
* and several others (default 3).

* ShowLegend .T. to show a legend (default .F.).

* And these are custom properties that you might wish to use:

* cColours A comma-delimited list of the colours to be use
* for the chart. The following colours are supported:
* red, green, blue, black, white, grey, gray, yellow,
* brown, magenta, cyan, darkblue, darkgreen
* For example, if the chart has three series, the following
* code will set these to blue, white and yellow
* respectively:
* THIS.cColours = "BLUE,WHITE,YELLOW"
* (these are not case-sensitive)

* cFootnote Text of a small title which appears at the bottom
* of the chart

* cTitle Text of a main title for the chart; this appears
* centred at the top of the chart

* lIgnoreZero If .T., any zero values in the data will not
* be plotted. (Default .F.).

* lShowMarkers If T., data points will be highlighted by special symbols.
* (Default .F.)


* Creating the chart

* Once you have set the required properties, call the control's
* CreateChart method. This will read the cursor, populate the
* chart with data, and display the chart. The cursor must be open
* when you call this method.


* Things that can go wrong

* If the CreateChart method is unable to create the chart, it
* will return .F. and the chart will not appear. If this happens,
* you should check the following:

* - The cursor or table containing the data must be open, and
* its alias stored in the cAlias property.

* - The cData property must contain the name of at least one of
* the (numeric) fields from the cursor.

*

[janlih]

請問樓上大大，table已開，也有數值欄位，可是run後無法顯示，system32資料夾也有mschrt20.ocx

use gcdatapath+"simplechart1.dbf" alias chart1 in 0
select chart1

with thisform.simplechart1
.calias = "chart1"
.cdata = "sales_val,sales_qty"
.crowlabels = "month_name"
.clabels = "value,Quantity"
endwith

已解決

最後要加入 .createchart()

[garfield]

這是另外一套優質統計圖軟體 FoxCharts
http://weblogs.foxite.com/vfpimaging/archive/2008/04/04/5919.aspx
show一張demo給你看看.


已經納入vfpx 裡面, 後續開發沒問題.
下載網頁:
http://www.codeplex.com/VFPX/Release/ProjectReleases.aspx?ReleaseId=12847

[ericchuang]

[ezpos]

下載點 沒有了

[tuberose]

主页找：http://vfpx.codeplex.com/
或者在：http://vfpx.codeplex.com/releases/view/106904

[ckp6250]

這個也是好貨
google chart api
簡單易用跨平台
若是新學製圖的話，最好不要花心思在vfp

[ezpos]

請問大大
為何 我編譯成 .exe執行檔案
統計圖表 是空白的

在vfp開發環境是正常的

[Abel]

回覆 ezpos 大

整支程式開發完成後，移機至 User 電腦中有兩個注意要件
1. system.app 需隨程式分發，路徑置於 config.fpw檔 內的 DEFAULT 指定中 (預設路徑)
2. vfp9 RunTime檔 (程式所在執行路徑中) 一定要是 sp2 版本以上(含)，如果是低版本會有兩種情形

a. 出現錯誤「 無效的 SYSTEM 成員 」
b. 程式雖然能執行，但是 主Form 中的「圖表」不會出現

以上是個人心得