>>>>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.
>
Thanks Craig! I was just about to do a search to see if there was any sample code on how to use the CR ActiveX. Although I have the one that came with VS98 (I think 4.6) and the calls are somewhat different. Thanks again.