crBold?
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9438
Printed Date: 01 May 2024 at 11:09pm
Topic: crBold?
Posted By: swatts
Subject: crBold?
Date Posted: 19 Mar 2010 at 6:26am
|
My associate is making a formula that goes something like this: if not isnull {her.field} then "This is" & {her.field} and she wants "This is" in bold. Any way for this? |
Replies:
Posted By: DBlank
Date Posted: 19 Mar 2010 at 7:01am
|
Make a text box with " This is "
Highlight only 'This is" and make it Bold
Drag {Her.Field} into the text box and drop it at the of the string.
Select the whole text field,
right click and select Format Text
In the suppress formula field put
isnull({her.Field}
|
Posted By: JimNicholson
Date Posted: 19 Mar 2010 at 7:46am
|
You could do the following as an alternative:
IF not isnull mailto:%7b@PlanType - {her.field } then '<b>This is</b>' & {her.field}
Place the field in the report
Right click the field and choose "Format Field"
On the paragraph tab, go to the section labled "Text Interpretation" and chose HTML text.
That should do it too.
|
Posted By: DBlank
Date Posted: 19 Mar 2010 at 7:56am
|
Thanks for that Jim. I always forget about the HTML interpretaion option
 |
Posted By: swatts
Date Posted: 19 Mar 2010 at 8:05am
| Thanks, guys. I am getting it to her now. |
Posted By: swatts
Date Posted: 19 Mar 2010 at 8:10am
| Here seems to be the issue. She wants the "This is" to not show up unless there is something in her.field and then the other issue is that the second way to do it shows all of the title in bold whereas she only needs "This is" in bold. |
Posted By: DBlank
Date Posted: 19 Mar 2010 at 8:33am
|
1. That is why I put the conditional suppress on the text box
2. Hard to tell without seeing but likely she put the end tag for the </b> int he wrong place or she also has the whole formula field marked to be bolded wich will override the formula code. UNbold the field to see if works.
|
Posted By: JimNicholson
Date Posted: 19 Mar 2010 at 8:33am
|
IF not isnull ( mailto:%7b@PlanType - {her.field }) then '<b>This is</b>' & {her.field} Should return only values, if it's null, it won't return anything.
Be sure that the </b> tag is at the end of the This is text and NOT after the {her.field} name. It only bolds what is in between the <b> and </b> tags.
|
Posted By: swatts
Date Posted: 19 Mar 2010 at 8:42am
| Jim, she missed something. Doing that worked. Thanks again. |