Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: hyperlink Post Reply Post New Topic
Author Message
EVSchmidt
Newbie
Newbie
Avatar

Joined: 09 May 2019
Location: United States
Online Status: Offline
Posts: 4
Quote EVSchmidt Replybullet Topic: hyperlink
    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
IP IP Logged
Valert16
Groupie
Groupie
Avatar

Joined: 21 Mar 2016
Location: Spain
Online Status: Offline
Posts: 57
Quote Valert16 Replybullet 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.

Edited by Valert16 - 14 May 2019 at 2:00am
IP IP Logged
EVSchmidt
Newbie
Newbie
Avatar

Joined: 09 May 2019
Location: United States
Online Status: Offline
Posts: 4
Quote EVSchmidt Replybullet Posted: 14 May 2019 at 4:31am
Thank you!
That works- great
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.