A few questions about linking .. (with increasing difficulty :)

[aplusc]

a) Is it possible to link a field to a website (i.e. when it's clicked on)?

b) Instead of linking to a static website, is it possible to change the URL so that the field value is passed? For example the field I'm linking is AccountNumber. Would it be possible to somehow link to

http://www.mysite.com/test.asp?ACCT=ACCT#HERE.

Maybe a formula or something like that?

c) The AccountNumber field is 8 characters long. The first 3 are the branch, the last 5 are the actual number. I need to somehow split it then link it

http://www.mysite.com/test.asp?BRANCH=989ACCT=12345.

(In this case the field value was "98912345&quot

Any help would be appreciated.

 

[dgillz]

You can make a hyperlink as a part of your report is that is your question. Format the field and check out the hyperlink tab. Valid options are email address, website and filename.

Then you can dynamically make a different hyperlink for each record. Just use a formula field:

+"

http://www.mysite.com/test.asp?ACCT="+{AccountNumberField}

or

+"

http://www.mysite.com/test.asp?BRAN...uot;ACCT="+right({AccountNumberField},5)

Should take care of your 2 examples.

You may have to use the totext() function if the account number is not an alphanumeric field. See the help files on totext() for arguments on how to get rid of thousands separators and decimal places if you go this route.

Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com

 

[kenhamady]

Keep in mind this isn't available in all versions of CR, only the later versions. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com