Dynamically underline a text box Crystal Xl

Posted on 2009-04-20
Last Modified: 2012-08-13
I am dynamically changing the text that appears in my report column headers and the column detail, contingent upon a user's selection.  I would like modify my current formula that creates these headers to underline the header . Can this be done?

Formula looks something like this.
'Date' + CHR(10) 'Started'  which produces the following result:  I would like to underlind Started.


Question by:cookiejar
    LVL 9

    Expert Comment

    You may be looking for the wrong thing.  Look for defining the bottom border of the text box and not formatting the text.
    LVL 3

    Expert Comment


    To do so, right click on the text object, go to Format editor by selecting Format text, click on the formula edit button to the right of "Bottom:" then create a fomula whose result is crSingleLine or crNoLine.  For example

    if <<UserSelection>> = <your criterion here> then
    crSingleLine else

    Open in new window

    LVL 16

    Accepted Solution

    yes this can be done. But there are other ways as well. For this example do the following.

    Change your formula to this..

    Add the formula to the report. Right click on the formula. Go to format field. Go to the paragraph tab. In the low section there is a option called Text interpretation. In the drop down change it to HTML text. Click OK.  You will need to resize the field a bit to see everything but this should do it.  Crystal has the ability to read HTML code. The <br> is a line break and the <u></u> is for underline.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    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

    18 Experts available now in Live!

    Get 1:1 Help Now