• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3013
  • Last Modified:

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
0
Durbanpoison
Asked:
Durbanpoison
  • 5
  • 4
1 Solution
 
crgary_txCommented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now