[RESOLVED] Formula that Concatenates Strings - Can One Be Made Bold?

[The_Grudge]

I have the following formula:

IF ISNULL ({CSU_CLINIC_INFO.CLINIC_NUM}) Then 
  IF {CSU_CLINIC_TYPE.CLINIC_ABRNAME}= 'NORM' Then
     {LOCAL_DOC.DOC_NAME}
  Else
     {LOCAL_DOC.DOC_NAME}+ ' [' + {CSU_CLINIC_TYPE.CLINIC_ABRNAME} + ']'
Else
  {CSU_NURSE_CLINIC.NURSE_CLINIC_NAME}

I want the LOCAL_DOC.DOC_NAME (bolded above) to be normal font, while the CSU_CLINIC_TYPE.CLINIC_ABRNAME is displayed as bold in the report. Is that possible?

[rasinc]

Format the field with the Text Interpretation of HTML then change your code to:

IF ISNULL ({CSU_CLINIC_INFO.CLINIC_NUM}) Then 
  IF {CSU_CLINIC_TYPE.CLINIC_ABRNAME}= 'NORM' Then
     {LOCAL_DOC.DOC_NAME}
  Else
     {LOCAL_DOC.DOC_NAME}+ ' <b>[' + {CSU_CLINIC_TYPE.CLINIC_ABRNAME} + ']</b>'
Else
  {CSU_NURSE_CLINIC.NURSE_CLINIC_NAME}

See if that works for you. It should work in Crystal XI but I'm only assuming you are using Crystal.

[The_Grudge]

It just prints the <b> in the string, it doesn't format it any differently.

I'm using Version 11.0.0.1282

[The_Grudge]

Got it working. I needed to right-click on the field and set the "text interpretation" to HTML.

[rasinc]

Post your code. I tried it in one of my reports and it worked. It worked for me in CR8.5 and I just copied the same code into the same report in CR XI R2 11.54.12.1838

I just used this code

"<b>Help</b> - " & ToText(1000)

Help is bolded, the - 1000.00 is not

[rasinc]

OK, glad it's working now.

[The_Grudge]

Just one more question....How would I go about adding one more clause to the statement below.

I now want to say IF the field "SPECIAL" is = "Y", then make the whole text field GREEN.

IF ISNULL ({CSU_CLINIC_INFO.CLINIC_NUM}) Then 
  IF {CSU_CLINIC_TYPE.CLINIC_ABRNAME}= 'NORM' Then
     {LOCAL_DOC.DOC_NAME}
  Else
     {LOCAL_DOC.DOC_NAME}+ '<b> [' + {CSU_CLINIC_TYPE.CLINIC_ABRNAME} + ']</b>'
Else
  {CSU_NURSE_CLINIC.NURSE_CLINIC_NAME}

[rasinc]

Go into the format editor of the field, select the Border tab and use the conditional formula editor beside background. In this area the idea is

IF the field Special's CurrentFieldValue is "Y" then make it go green.

There is a Formatting function for CurrentFieldValue. The rest should be clear.