Solved

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

Posted on 2009-07-01
3
421 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Update 21-May-2015: I temporarily removed the source code to make major changes to the program. Regards, Joe In a previous Experts Exchange article, How To Rename-Move a Batch of PDF Files Based on Contents of the Files (http://www.experts-exchan…
In this first video of the three-part Xpdf series, we introduce and describe Xpdf, a library containing nine command line utilities that perform various functions on PDF files. We show where the library is located and how to download it, discuss its…
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…

685 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