Has anyone out there got experience of calling a Visual FoxPro report from a .net application? They want to both see the report and print it.
I have to migrate a FoxPro application to .Net and the client would like to keep the FoxPro database + reports but place a new .Net front end on it.
They have extensive Fox reports that they would like to keep. Has anyone tried this?
I haven't tried this personally; however Foxpro for Windows projects (at least since v.7.0) have had the capability to be compiled as COM objects which might be useful in this situation. Also, in version 9.0 they added the report listener capability which allows you to exert a lot more control over reports. Between these two capabilities, you should be able to call the reports from .Net.
And as far as accessing fox tables, Microsoft does offer the OLE methods for interacting with them.
Microsoft OLE control for VFP 9.0
Sorry I don't have the answer but hopefully the links will help.