Solved

Bold string in a formula field

Posted on 2014-11-07
2
242 Views
Last Modified: 2014-11-13
How do I go about bolding part of a formula field that is a string?  
My formula is as follows and I want to bold the string: *DTC*

if {receiver.r_ussname} startswith "DTC" then
    {receiver.r_letter}& " *DTC*"
Else
    {receiver.r_letter}


Thanks!
0
Comment
Question by:IO_Dork
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 40429197
I can think of 2 ways to do this.

1.  Add a text box to the report where you want to display
     Drag the {receiver.r_letter} field into the box
     Change your formula to
if {receiver.r_ussname} startswith "DTC" then
     " *DTC*"
 Else
    ""

Open in new window

   Drag the new formula into the text box
    Right click the text box
    Click EDIT
    Select the formula field
    Set it BOLD through the ribbon

2.  Use your formula but add HTML or RTF encoding to it
if {receiver.r_ussname} startswith "DTC" then
     {receiver.r_letter}& " <b>*DTC*>/b>"
 Else
     {receiver.r_letter}

Open in new window

Put it on the report
Right click it
Click FORMAT FIELD
Click the COMMON TAB
Set the interpretation to HTML

mlmcc
0
 

Author Closing Comment

by:IO_Dork
ID: 40441191
thanks!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

717 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