Hello,
My question is regarding using Crystal Reports to link multiple Word documents together. We need it such that we can make changes to the Word files, and the Crystal report will automatically reflect these changes (the next time it's opened). Turns out that this is a not so simple task. I thought that I could use the FoxPro 'General' field type to store a link to the Word document like this:
APPEND GENERAL tgeneral FROM W:\ICOSNPD\acord.doc LINK CLASS "Word.Document.6"
Well, that apparently isn't very efficient and creates large .FPT files. Still, I suppose I'd be willing to deal with that.
After this, I figured I could just drag the general field onto the Crystal Report and it would work like I wanted. Well, not much luck here. The rpt doesn't seem to be getting updated when I make changes to the original Word document. I noticed that if I embed the Word file in the General field, then it seems to work how I want it, but then that brings up a whole lot of other problems.
What is the best route I can take with this? I wish there was a way I could just store the paths to the files (which actually are already stored elsewhere in the database) and just tell Crystal where to find the Docs.
Any help will be greatly appreciated. Thanks!
We're using FoxPro 6.0 and Crystal 8.5