Skip to Content

Crystal Reports - Link to external pdf file names and embed into report - Possible?

I need to link an account number in a Crystal Report to an account number that is part of an external pdf file name and embed each pdf file into the report.

Is this possible to do in Crystal Reports? And, if so, how?

Thanks for any help!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Nov 10, 2016 at 04:54 PM

    Thanks for everyone's help and suggestions!

    I found a solution that worked for me by using 3rd party software, Visual Cut.

    In my Crystal report, I created a formula field that concatenated my field names to create paths to my pdfs. Using a variable, I was able to create a csv list within my report that takes the first pdf on the list and appends the next pdf to it.

    Then utilizing Visual Cut, I was able to export (burst) combined pdfs containing the information I needed.

    Also, thanks to Ido Millet at Visual Cut for his assistance in creating the report logic and formulas to make this work!

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 07, 2016 at 05:58 PM

    Hi Cheryl,

    This could be a huge security issue but try this...

    Insert an OLE Object and browse to one of the PDF files and Link it:

    and insert it into your report.

    Now right click on the object and select Format Graphic,

    Select the Hyper link tab and select File and click on the Link:

    Now click the X+2 ( formula editor ) button and add something like this:

    "d:\document" + "123" + ".pdf"

    "123" being the account number.

    See if that works for you

    Don

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks, Don.

      I tried it, and it pulls the first page only of the first pdf and repeats that on all pages.

      Upon further investigation, we did discover that these pdfs (which come from an outside source) have some password protection preventing editing but not preventing reading. Not sure if this would prevent correct embedding of all files/pages, but could be possible.

      Otherwise, if there are further suggestions, that would be appreciated!

  • Nov 09, 2016 at 06:05 PM

    Hi Cheryl,

    And you are updating the account number each time correct? You may want to put the account number into a database field, as a test to see if that works.

    Typically what happens id you link to a file it only loads the file when the report is loaded, it does not refresh each one unless it is linked to a database field.

    So the formula would look something like this:

    "d:\document" + {DB.AccountNumber} + ".pdf"

    That may work for you...

    Don

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 09, 2016 at 09:49 PM

    Hi Cheryl,

    If you are embedding the PDF into a report to see the document, only the first page will open. If you want to see the entire document then you can double-click on the PDF in the report and it should open in your PDF viewer. Crystal won't display multiple pages from a PDF document.

    Thanks,

    Brian

    Add comment
    10|10000 characters needed characters exceeded