Hi Mark,

>Scenario is really simple. You have VFP back-end program (called via isapi or ASP or something else). That program works on data and gets a cursor ready to be printed. Then you call CR COM to actually do printing. You dont have to much choices to pass data to it. Tables? But what about simultaneous requests to the same report?

Actually FOX2X tables could serve you very well. The VFO COM object could save the result into a FOX2X table with a random name (by something like):

 Make your SQL Statement

cFile=SYS(2023)+"\"+"_"+SYS(3)+".dbf"
COPY TO (cFile) FOX2X

oEngineObject = CREATEOBJECT("CrystalRuntime.application")
oReport=oEngineobject.openreport(cReportname)

oReport.Database.Tables.item[1].location = cFile
oReport.Printout(.F.)

DELETE (cFile)

In this way cuncurrent reports should not be a problem. However I don't know how the CR RDC engine internally handles concurrency though.


Good luck,

Walter,