• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 75
  • Last Modified:

How to Bold a formula within another formula

How can I bold {@DisplayPersonQualifier} results within another formula.

Formula: DisplayPersonwithQualifier

{@DisplayPersonQualifier} & ' - ' & {@DisplayPerson}
0
MikeM670
Asked:
MikeM670
  • 2
  • 2
1 Solution
 
mlmccCommented:
Without resorting to HTML or RTF coding, it is not possible.

That said there is a way to do it

Add a text box to the report
Drag  the {@DisplayPersonQualifier} formula into the textbox
Type the "  -  " in the text box
Drag the {@DisplayPerson} formula into the textbox

Right click the textbox
Click FORMAT TEXT
You can now format each individual part of the text box independently so the first part can be bold

mlmcc
0
 
MikeM670Author Commented:
Hi mlmcc,

I was hoping for a more elegant solution but maybe I should of asked this instead.  Below is the
DisplayPersonQualifier formula's code.  Would it be possible to do the "Bolding" within this formula before it is called by the DisplayPersonwithQualifier?  I have tried various approaches but nothing would work.



local stringvar Qualifier1;
local stringvar Qualifier2;
local stringvar Qualifier3;

if not(isnull({CasePerson.Qualifier1})) and trim({CasePerson.Qualifier1}) <> ""
then Qualifier1 := ProperCase ({CasePerson.Qualifier1});

if not(isnull({CasePerson.Qualifier2})) and trim({CasePerson.Qualifier2}) <> ""
then Qualifier2 := ', ' & ProperCase({CasePerson.Qualifier2});

if not(isnull({CasePerson.Given3})) and trim({CasePerson.Given3}) <> ""
then Qualifier3 := ', ' & ProperCase({CasePerson.Given3});

Qualifier1 & '' &  Qualifier2 & '' & Qualifier3;
0
 
mlmccCommented:
The only way would be to use HTML encoding

Not sure which part you want bold

Change last line to

'<b>' & Qualifier1 & '</b>' &  Qualifier2 & '' & Qualifier3;

Right click the object on the report
Click FORMAT FIELD
On the PARAGRAPH tab
Set TEXT INTERPRETATION to HTML

mlmcc
0
 
MikeM670Author Commented:
Once again you provided the solution and I've learned a new feature using HTML!!
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now