Dynamically inserting Word documents in to Crystal Reports

Hello All

I need to dymanically insert a number of word documents in to a Crystal Report, basically I have a table with records containing names and details and a field called filename, I need to print a page per record with the name and then the word document for each person below their name on each page.

I am using CR11 R2 and have tried using an embedded OLE object. Also tried changing the graphic location as well.

Any ideas?

Cheers

Durban
DurbanpoisonAsked:
Who is Participating?
 
crgary_txConnect With a Mentor Commented:
There are 2 bugs in CR 11 wrt to dynamic linking of OLE.
1. You cannot load a word/pdf document specified by the path stored as a db field.

2. You can load the word doc by specifying the path in Crystal. But it just loads the first page if the word document spans across multiple pages

Gary
0
 
DurbanpoisonAuthor Commented:
Hmm, well, all my word docs are only 1 page so no worries there.

The path for my word doc is read from a db well part of it anyway.

Would you mind explaining how I would go about it if I was to use option as you mentioned above?

Also, does all this work in CR10 at all?
0
 
DurbanpoisonAuthor Commented:
Sorry meant to say option 2 above
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
DB-ITCommented:
Hi durbanpoison,

       Are you able to resolve your requirement of insert a document dynamically into CR? I have the same requirement too. Hope you can help me out. Thanks
0
 
DurbanpoisonAuthor Commented:
I can't recall mate.

I don't think I ever found a solution though, I would remember of so.
0
 
DB-ITCommented:
Thanks for the prompt reply. Did you use an alternative since you did not find a solution to it?
0
 
DurbanpoisonAuthor Commented:
hehe, my solution was a bit drastic.

I axed the system and developed a different one....

What are you trying to achieve?
0
 
DB-ITCommented:
Rather simple goal, to display drawings or product specs (pdf format) of a product in CR as a reference for the production/procurement people. The data comes from our ERP item master using MS-SQL 2005 database
0
 
DurbanpoisonAuthor Commented:
completely guessing here but what about trying to dynamically create a link to the relevant document rather than inserting it? so it can be opening in a web browser
0
 
DB-ITCommented:
We have pre-attached the documents in the ERP system. So, i only have to fetch from the database directly. Anyway, i shall give your suggestion a thought and see how it goes. Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.