hyperlink
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22771
Printed Date: 02 May 2024 at 12:15pm
Topic: hyperlink
Posted By: EVSchmidt
Subject: hyperlink
Date Posted: 13 May 2019 at 5:56am
|
First post:
General information: I am trying to use a hyperlink in a report which has numerous file names minus the path. Note: i could include the path if it helps. It would be the same for all. I would like the hyperlink to display the PDF or HTML file when selected. I can manually select and create a hyperlink for each report file name by formatting the part field, selecting Hyperlink, and select "A File" The challenge is that, I would like Crystal to create them during the refresh process and not rely on manual creation for each. There are thousands of these PDF files to link. I think there is a way to use the "Hyperlink Information field with a "X-2" to make it happen, but all my attempts have failed. Example data: Part number Description CB000123.pdf Widget, blue CB000405.pdf Cog, purple ........pdf part name etc. CB012349.pdf last part in list. Crystal version: Using Crystal Reports 14.0.12 I would appreciate your help. Thank you 
|
Replies:
Posted By: Valert16
Date Posted: 14 May 2019 at 1:45am
|
I assume the field "Part number" always contains the name of a pdf or html file.
If you know the path, you only need one line of code. Let's say the path is "C: \ MyFiles". Then your hyperlink formula for the file name must look like: "C: \ MyFiles" & "\" & {TableName.Part number} Replace path, table and field names by yours. If you want to change the path easily, put it in a parameter or in a separated formula. |
Posted By: EVSchmidt
Date Posted: 14 May 2019 at 4:31am
|
Thank you!
That works- great 
|