Need help with creating a formula to access a hyperlink 1

[scotsbloke]

Hi,

Thanks in advance for any help anyone can offer on this one.

I have searched through the Crystal Formula syntax but can't seem to find code to help me with the following. I may have overlooked it and if so then feel free to hit me round the head with a big stick with nails in the end!

Anyway, my report it linked to an access database. On the PH of the report I have a field which displays the current customer the report is viewing. To save on report size (paper wise) I want to allow the user to click on a hyperlink that looks at the PH field, identifies what current record they are viewing and selects the correct HTML file (containing more details on that customer). I'm thinking that 'if..then..else' is the best way forward (although possibly long winded) but can't find a syntax command that will open an HTML file specific to the current report data.

I can't use the hyperlink command in 'Format Text' as this only opens one specific html file.

Any ideas?

Mike

 

[kenhamady]

what version of CR? Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[scotsbloke]

sorry, forgot to mention that its 8

 

[kenhamady]

You can write a formula that constructs the path as a string. Select the "FILE" radio button and use the X+2 button next to the slot for putting in the link path.

The formula would look something like this:

if {Customer.Region} <> &quot;PA&quot;
then &quot;\folder\&quot;+{Customer.Region}+&quot;.html&quot;
else &quot;\folder\PA.html&quot;
Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.