Solved

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

Posted on 2009-07-01
3
416 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:RQuadling
  • 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:RQuadling
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Getting information about Fonts being used in a PDF file A colleague of mine recently faced an issue related to the PDF file format. The PDFs were containing mission critical client information, they were successfully mailed but there was a sm…
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…
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…
In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

895 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now