Crystal Report - Text Box Applied as an E-mail Hyperlink

Posted on 2009-04-17
Last Modified: 2012-06-22
On my crystal report design we've create a request form. At to the top of the request form we a text box that is a hyperlink to an email address. Within format text - hyperlink, we have the code below for the e-mail address hyperlink which works great. We need to be able to add a database field to this, i.e. account number or borrower name. When we get the emails back, we don't know which record it's associated with. Is there any way to add a database field to email or should we approach this in a different way. Thanks. appraisal request has been accepted

Open in new window

Question by:asmyatt
    LVL 18

    Accepted Solution

    Use the formula builder from the hyperlink formatting tab and append your field to the mail string

    formula would look like this if you wanted to show the {?RequestID} parameter:


    " appraisal request has been accepted--RequestID = " & {?RequestID}

    After clicking the link, the mail message opens and the body reads:
    The Appraisal Request has been accepted--RequestID = 367-6778

    Maybe it would be better suited for your subject line but either way, the way to do it is to build a string in the formula builder
    LVL 2

    Author Closing Comment

    Exactly what I needed. Thanks.

    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…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    734 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

    20 Experts available now in Live!

    Get 1:1 Help Now