Solved

Crystal Reports with an Adobe Acrobat embedded via OLE does not refresh when image path changes.

Posted on 2009-07-01
3
417 Views
Last Modified: 2012-05-07
Hi.

Is there some clever trick required to get the "Graphic Location" on an OLE object to update when the data is refreshed?

The Graphic Location value is a database field. Each row has a different value.

The value changes (I can report upon the field easily enough), but the graphic location, if it is being updated, does not change the image.

The images are actually PDF documents.

The links are like this ...

\\DomainClusteredFileStore\FaxesReceived\2009\07\01\2009-07-01__12-29__Page-0309__249G6UK3.pdf
\\DomainClusteredFileStore\FaxesReceived\2009\07\01\2009-07-01__12-29__Page-0310__24IBTUSI.pdf
\\DomainClusteredFileStore\FaxesReceived\2009\07\01\2009-07-01__12-29__Page-0311__24R7GV1U.pdf
\\DomainClusteredFileStore\FaxesReceived\2009\07\01\2009-07-01__12-29__Page-0312__25033VAD.pdf
\\DomainClusteredFileStore\FaxesReceived\2009\07\01\2009-07-01__12-29__Page-0313__258YQVJP.pdf
\\DomainClusteredFileStore\FaxesReceived\2009\07\01\2009-07-01__12-35__Page-0314__25HUE0JF.pdf
\\DomainClusteredFileStore\FaxesReceived\2009\07\01\2009-07-01__12-35__Page-0315__25QQ10RV.pdf
...


Any ideas?

Regards,

Richard Quadling.
0
Comment
Question by:Richard Quadling
  • 2
3 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 24759422
Is this Crystal XI or 2008?

If not you have to store the image in the database.  Using the location string was added in CR XI.

mlmcc
0
 
LVL 40

Author Comment

by:Richard Quadling
ID: 24761320
CR 11.

The "images" are actual PDF documents which are single page reports which contain the fax and a small table of information about the state of the fax (received, processed by/date, invoiced, etc.)

The location of the image is a URL (intranet URL) supplied as a column in a view from the database. The SQL server creates the URL from a datetime, page# and a fax code.

We get around 800 pages a day.

0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 24766253
CR XI or 11 can use the database field directly as the source of the image.

mlmcc
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Update 21-May-2015: I temporarily removed the source code to make major changes to the program. Regards, Joe INTRODUCTION This article presents a solution to a question (http://www.experts-exchange.com/Programming/Installation/Q_28396542.html)…
Have you ever come up with a need of emailing only few pages of PDF file to one of yourfriend or colleague, instead of whole Adobe file? If yes, then surely you have face problems in doing that! Read this section as I have suggested multiple solutio…
In this second video of the Xpdf series, we discuss and demonstrate the PDFimages utility, which, in a single command, is able to extract all the images from a PDF file and save each one in a separate image file (PBM, PPM, or JPG). Download and inst…
Sometimes we receive PDF files that are in the wrong orientation. They may be sideways or even upside down. This most commonly happens with scanned or faxed documents. It is possible to rotate the view of these PDFs with the free Adobe Reader produc…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question