>>>Any help appreciated, trying to
>>>
>>>1. convert vfp reports to crystal reports
>>>2. integrate crystal reports with vfp
>>>
>>>thanks in advance
>>>
>>>yvonne_kingsley@nceb.uscourts.gov
>>
>>There's no way to convert. For integrating, use the Automation server rather than the OCX. Also, use PRGs to send your data to a FOX2X table, then have CR use that table for reporting.
>
>Hi Craig,
>I am just looking into using CR and looks powerful. but the documentation does not really tell me much about the automation server. How does one set it up? Same with the Web server. I have the icons in the task tray.
>I also have the only book on CR on order but it did not come in yet.
>
>Any tips would be appreciated.
>
>Peter

Look for the file Developr.Hlp in the Crystal Reports directory. Here's code that works for me. This creates an RTF file.


* Create the server instance
loCRApp = CREATEOBJECT("Crystal.CRPE.Application")

* Copy the data
COPY TO C:\FOXTEMP\MyDbf TYPE FOX2X

* Call crystal reports to create the Agency report
loCrReport = loCRApp.OpenReport("MyReport.Rpt")
loCrDatabase = loCrReport.Database()
loCrExportOptions = loCrReport.ExportOptions()

* Go to a file
loCrExportOptions.DestinationType = 1

* The file is RTF
loCrExportOptions.FormatType = 4
loCrExportOptions.DiskFileName = "MyOutput.RTF"

* Reset the data saved in the report
loCrReport.DiscardSavedData()

* Don't do any prompting
loCrReport.ParameterPromptingEnabled = .F.

* Create the RTF file
loCrReport.Export(.F.)

* Reset the CR Options
loCrExportOptions.Reset()

* Clear the report objects
loCrReport = .NULL.
loCrDataBase = .NULL.
loExportOptions = .NULL.