Hello.

We (me and my colleague) have recently been trying to design a rather unusual report which requires us to use Crystal Reports 4.5. Though we have no problem with generating the report itself, we need to fax the reports automatically using a Foxpro application.

So far, we've been able to connect to the fax and prepare it for sending (using DDE), but we need to manipulate our Crystal Reports report automatically before sending it.

Specifically, we need to accomplish the following steps:

- Open the CR report "document" (we've experimented with createobject, but ahve yet to find the proper command)

- Refresh the data source (we use an access database as data source)

- Send the fax

We have a Crystal Reports control we can use (crystl32.ocx), but we haven't found how to execute the above commands with it.

Also, is there any way to remotely "compile" the CR report (merging the data to the report) in Foxpro?

Any help would be appreciated.

Thank you.

Yan Vaillancourt
Programmer-Analyst