GRAPH IN REPORT 1

[Mistral2]

hi everybody,

In a report I want to show a graph in every line like this:

Qty 1999 Qty 2000 Qty 2001 QTY 2002 GRAPH

15 12 13 21 ?????
17 41 12 25 ?????
etc...

Anyone can help me ?
Mistral

 

[rgbean]

Mistral,
While not real elegant, you could create a text field on the report and then use an expression like:
REPLICATE("*", scaledvalue)

Where 'scaledvalue' is based on the number you want "graphed" and the number of characters you've allowed for the field to display.

Rick

 

[Mike Gagnon]

Mistral2

You may consider Automating Excel to create the desired graph (which is more suited for graphs), and pasting your graph in your report. Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[torturedmind]

What you can do is create a temporary file with just 1 General field and embed a MSGraph in that field. The graph itself will have its own values so you need change them with your own data (use the help file for an example on changing graph values). After that, create a report and an OLEControl containing the general field which in turn contains the graph.

Let me know if this helped.

torturedmind

 

[Mistral2]

Mike,
Please can you give me more details to do this.

Merci
Mistral

 

[Mike Gagnon]

Mistral2

Here as small example of how to make a chart in Excel with Visual Foxpro:

loExcel = CREATEOBJECT("Excel.application")
loExcel.Workbooks.add()
loActive = loExcel.ActiveSheet
loActive.Range("A1").Formula="1"
loActive.Range("A2").Formula="2"
loActive.Range("A3").Formula="3"
loActive.Range("A4").Formula="4"
loActive.Range("A5").Formula="5"
loActive.Range("B1").Formula="20"
loActive.Range("B2").Formula="30"
loActive.Range("B3").Formula="40"
loActive.Range("B4").Formula="50"
loActive.Range("B5").Formula="60"
objChart1 = loActive.ChartObjects.Add(100, 100, 200, 200)
loActive.chartobjects(1).chart.;
	chartwizard(loActive.range(loActive.cells(1,1),loActive.cells(5,2)),;
	-4100,4,1,0,1,1,"","","","")
loExcel.visible = .t.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[ggrewe]

Mike,

I found the reference for the ChartWizard in this article

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/xlmthchartwizard.asp

But I cannot find an article that gives the values of each of the possible options and what they correspond to. Can you tell me where to find that reference? Thanks much.

 

[Mike Lewis]

Mistral,

I have a bit of freeware called SimpleChart which will do the whole thing for you in about three lines of code.

If you would like a copy, you can get it from:

http://www.ml-consult.demon.co.uk/foxst-23.htm

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[DSummZZZ]

That looks spiffy Mike. I wish I had seen it sooner. * anyway.

Now there must be a way to do it on a VFP report....


-Dave S.-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[ggrewe]

Mike Lewis,

I downloaded your SimpleChart and it ran like a champ. Thanks much. But like Dave said, how can we print the resulting chart?

 

[Mike Lewis]

Ggrewe,

how can we print the resulting chart?

See my article "SimpleChart Revisited", at:

http://www.ml-consult.demon.co.uk/foxst-27.htm

NMike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk