Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: crBold? Post Reply Post New Topic
Author Message
swatts
Groupie
Groupie
Avatar

Joined: 17 Mar 2010
Online Status: Offline
Posts: 83
Quote swatts Replybullet Topic: crBold?
    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?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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}
IP IP Logged
JimNicholson
Newbie
Newbie
Avatar

Joined: 03 Dec 2009
Location: United States
Online Status: Offline
Posts: 7
Quote JimNicholson Replybullet Posted: 19 Mar 2010 at 7:46am
You could do the following as an alternative:
 
IF not isnull {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.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 19 Mar 2010 at 7:56am

Thanks for that Jim.

I always forget about the HTML interpretaion option Confused
IP IP Logged
swatts
Groupie
Groupie
Avatar

Joined: 17 Mar 2010
Online Status: Offline
Posts: 83
Quote swatts Replybullet Posted: 19 Mar 2010 at 8:05am
Thanks, guys. I am getting it to her now.
IP IP Logged
swatts
Groupie
Groupie
Avatar

Joined: 17 Mar 2010
Online Status: Offline
Posts: 83
Quote swatts Replybullet 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.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
IP IP Logged
JimNicholson
Newbie
Newbie
Avatar

Joined: 03 Dec 2009
Location: United States
Online Status: Offline
Posts: 7
Quote JimNicholson Replybullet Posted: 19 Mar 2010 at 8:33am
IF not isnull ({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.
 
 
IP IP Logged
swatts
Groupie
Groupie
Avatar

Joined: 17 Mar 2010
Online Status: Offline
Posts: 83
Quote swatts Replybullet Posted: 19 Mar 2010 at 8:42am
Jim, she missed something. Doing that worked. Thanks again.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.