Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crystal and data
Message
From
06/07/2000 15:47:15
 
 
To
06/07/2000 13:40:57
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
00388863
Message ID:
00389083
Views:
18
>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,
Thanks
Previous
Reply
Map
View

Click here to load this message in the networking platform