Solved

Bold string in a formula field

Posted on 2014-11-07
2
238 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
2 Comments
 
LVL 100

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Crystal Report Filter Question 6 63
C# Crystal Reports 15 88
Crystal Report detail 15 46
Cyrstal Reports formula to check IsNull 8 31
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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

776 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