View PDF and Word file

[Former Member]

Post Author: vcharles

CA Forum: Crystal Reports

Hello,

I am using crystal report XI with ACCESS 2003, I would like to create a field in my ACCESS table to insert the path of the PDF or word files I would like to view when I click on the report. Is there a way to do this? Whic is the best approach to view a PDF or Word document from the crytal report viewer?

[Former Member]

Post Author: pvierheilig

CA Forum: Crystal Reports

Just so I get the first part correct - this is what I understand you to want to do:Add column to Access db, say something like 'FILE_LINK'Have a field on your report that displays the value of the FILE_LINK data for either PDF or DOC's. To do this:Populate the Access db as you'd like, including the file extension.Add the database field to the report.Right-click the field and 'Format Field'.Select the 'A File' radio button.Select the Hyperlink tab.Select the 'X-2' button in the 'Hyperlink Information' area of that same tabbed window.Enter a formula for what you want to be shown. To show 'somefilename.pdf' on a shared drive, for example, enter this formula:"
x\" & {database.column}Click the 'X-2' icon with the green checkmark, near the top-left of the window. Fix any errors reported.Click 'Save & Close' and then 'Ok' on the 'Format Editor' window.Drop/drag the field where you'd like it and you should be good to go.