Liveware Publishing Support Forum

How can I call a front-end FoxPro program once at the beginning of a report to build a master table? I have not been able to successfully create a database/query combination which includes the data I want for my report.

Conrad,____I think the solution is to run the foxpro front end first and have it build a set of temporary files which have key data to relate back into your regular VFP files. In a multi-user environment, you can build the temporary files with a naming convention and then alias the master file and the related files by passing a control file record.____Then call the RR runtime and pass it the name of the control file with the report^s name, aliases, etc. The temporary file(s) you create will only have the keys to the records that satisfy the filter conditions you used in VFP.____We have found that this works very well and both fast and stable. __We^ve been doing it for years in all versions from 6 to 10.____Hope this helps. Send an email if you want some more info.____-Pat-