Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is it possible to insert a graph in a report?
Message
From
04/02/1998 12:21:26
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
04/02/1998 12:02:22
Marco Battisti
Zucchettitools Srl
Bellaria, Italy
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00076259
Message ID:
00076273
Views:
54
>I want to insert a graph printing into a report.
>
>I use VFP's Report Designer and Microsoft Graph to generate the chart.
>Clearly i want to print the graph after the whole printing of data.
Hi,
You put the graph on a cursor gen field then add that gen field to report. Here is an example from one of my programs.
select str(year(tarih),4)+"/"+str(month(tarih),2) as Ay, sum(kilo) as Kilo ;
	from (dbname) ;
	where tarih between ldStart and ldEnd ;
	and cari_no # trim(depodata[1]) ;
	group by 1 into cursor query
M.CGDATA = ""
scan
  m.cgdata = m.cgdata+TAB+ay
endscan
m.cgdata = m.cgdata +crlf+"Kilo"
go top
scan
  m.cgdata = m.cgdata+TAB+str(kilo,7)
endscan
graphType = 4
graphsubType = 4

create cursor foo (gen1 g)
append blank
append general gen1 class "msgraph.chart" DATA M.CGData
report form repgraph to printer noconsole
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform