Href Phone Field

Posted on 2012-08-28
Last Modified: 2012-09-14
I have a report that I need to Href the phone field. . .
I hope that those who helped me here will continue:
Question by:Starquest321
    LVL 26

    Assisted Solution

    by:Kurt Reinhardt
    href is just a hyperlink.  What version of Crystal Reports are you using?  In modern versions, you can simply right-click the field, click the Hyperlink tab and create the link.  What is it you're specifically trying to do?

    Author Comment

    I have a field value. .a phone number that is taken from the database.
    I need that field to be href with the following tag: tel://{field value}
    How can that be done?
    LVL 34

    Assisted Solution

    As Kurt asked, which version of CR?  Different versions may have different options.

     What do you expect a tel:// link to do when you click on the field?

     I have no idea if the link will actually do anything, but in CR 10, you can add it like this:

     Go to the field format and select the Hyperlink tab.
     Select one of the Hyperlink types (to enable the "Hyperlink Information" section below).
     Under "Hyperlink Information", click on the formula (X+2) box to the right of the address box and enter a formula that combines "tel://" and the phone number field.  The exact form will depend on whether the phone number field is numeric or string, and how you want the number formatted in the link.

     For example, if the field is numeric and you just want the digits (eg. 1234567), you could use something like this:

    "tel://" + CStr ({phone number field}, "#")

     Like I said, I have no idea if that will do what you want.  I just got an "unable to open hyperlink" error when I tried it.


    Author Comment

    What I want to do is to integrate the SKYPE calling hyperlink in the report. So when you click on the the number it will dial!
    LVL 26

    Accepted Solution

    For Skype, this worked for me:


    Please note, that assumes the phone number is already a text field in a straight numeric format, such as '5555555555'. The number of characters will differ based on country code, if applicable.

    Follow James' instructions on how to create the hyperlink field.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now