Milicent,

>Hi Walter,
>I am not a premier member and cannot access the message u sent to Jennifer Blincoe on 04/03/2000 is it possible for u to email me a copy of send me the message? Id be very greatful
>
>Thank You
>Millicent Graham

First off all, you don't have to be a premier member, go to the calendar click the appriopriate day and search for the message.

You can also use the search button to search on Walter and Crystal to find more topics about intergration of crystal reports in VFP.

below the message I sent to Jennifer,

>Help How do you run a crystal report from visual foxpro 6.0

In my reply, I'll assume you use CR version 6.0 or up.

there are several way's to integrate Crystal Reports within your VFP application:

- the crystal Reports activeX control, the most simple and straightahaid method, but here you\ve somewhat limited control over preview and print options.

- the CR API, the best way if you want to distribute CR with C/C++ programs, It also seems the only way to include CR with FPW 2.xx versions. This approach is hard to do with VFP because a lot of these api's require structures and if you're doing only 1 thing wrong you'll end up with a general protection fault.

- the CRPE32 automation server. This one gives your more control over the report settings. However, this method is being discontinued so no further developing will be done on this strategy.

- The RDC automation server, if using CR 8.0, 'll give you maximum control over report, preview and print settings.


So the best bet is to use the RDC automation server. Though personally I use the CRPE32.DLL automation server, I've done some investigation on the RDC automation server.

For handling previews, you've got to include the crystal reports smart viewer (activex) control. This activeX control will give you the preview ability. Some hint to get this report to print or preview:


x=createobject("CrystalRuntime.application") && open the RDC automation server
orep=x.openreport(cReport, 1) && open the report
orep.EnableParameterPrompting=.F. && disable the prompt for paramters

THISFORM.Rep=oRep && store the report obejct in a custom form property
THISFORM.CrViewer.ReportSource=oRep && ActiveX smartviewer control
THISFORM.CrViewer.Viewreport() && Display the preview

OR

THISFORM.Rep.Printout(.F.) && print the report


For other hints, go to search, search on 'Walter crystal' or see the developers help that comes with crystal reports.

good luck,

Walter,