How do you add a bold function to formula? 9

[stormtrooper]

How would I go about making the parameters of this formula bold faced?

totext(minimum({?Parameter})) + " to " + totext(maximum({?Parameter}))

 

[bjrollet]

Easy. Right click on the field object, choose Format Field. Click on the Font tab, and then the x+2 button. You can then enter a formula to conditionally bold the field.

 

[bjrollet]

Follow up. This will bold the entire field based on conditions, I think you may want to bold just the parameter values alone. Am I correct?

 

[stormtrooper]

Yes. Just the parameter values.

 

[dgillz]

I do not believe this can be done as you have asked for it.

I do have a workaround. Create 2 formula fields:

ToText(Minimum({?Parameter})) and
ToText(Maximum({?Parameter}))

Place them on the report where you want them to appear, and format them as bold. Then insert a text object inbetween these two fields and make it say " to ", without the bold letters.

If there is a way to bo this within the formula you posted above I would love to know what it is. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[Ngolem]

dgillz's solution is the only one I'd use if you want the parameters individually bolded.

DON'T do the following: create the individual formulas and bold them ....then embed the formulas into a text field with the word "to" in it....this will lead to a performance hit and is tougher to maintain Jim

JimBroadbent@Hotmail.com

 

[stormtrooper]

Thanks. I appreciate your help.

 

[rosemaryl]

Dear All:

The solution is HTML formatting tags.

This works, but you have to be careful of placement as the html tags must be inside of text indicators " ". You can start them in one and end them in another, but to accomplish this one I had to add them:

Format the formula field, paragraph formatting tab, Text Interpretation: HTML Text and perform the following:


&quot;<B>&quot; & totext(minimum({?Parameter})) & &quot;</B> to &quot; & &quot;<B>&quot; & totext(maximum({?Parameter})) & &quot;</B>&quot;

The results should be as desired!
Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[dgillz]

Wow I had no idea you could do this at all and I have been working with CR for 5 years.

Thanks Rosemary. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[bjrollet]

rosemaryl, we are NOT worhty. A most excellent post. I too, have been working with CR for some time and I had no clue that you could do that. This opens up many more possibilities for report formatting. Again, thanks a million.

 

[Ngolem]

I will add my kudos as well....I also never heard of this possiblity. Where did you learn it...desperation and tried it or another source

Most usefull...thanks.
Jim

JimBroadbent@Hotmail.com

 

[Ngolem]

this must be available for only CR8 +

I tried it in CR7 and it doesn't work...but still useful if it works in CR 8

&quot;Format the formula field, paragraph formatting tab, Text Interpretation: HTML Text and perform the following:&quot;

The above is a major key to this and of course this is not available prior to CR8...didn't read this closely when I tried it. Jim

JimBroadbent@Hotmail.com

 

[rosemaryl]

Dear All,

(Humbly blushing!) Thanks.

I discovered this because I was writing two courseware books for Network Associates (Crystal 8.0 Basic for MagicTSD 7.0 and Crystal 8.0 Advanced for MagicTSD 7.0).

The users of Magic had been stuck on Crystal 7.0 for quite a while and a new release of the Magic application included Crystal 8.

NAI wanted totally new documentation and so I was going into every single menu option and testing stuff for exercises when I noticed the HTML interpretation and then tried embedding tags. Wonder of Wonders it worked after figuring out that it had to be in text strings!

I haven't tried a lot of tags, but I am assuming that common ones will work.

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[chelseatech]

Well done Rosemary. Excellent sugegstion

We discovered HTML text interpration a while ago and most of the HTML tages for colors, fonts styles and sizes work well.

Also useful for superscript and subscript.

What I'd like to see is it to be able to process <IMG> tags - then we have dynamic images in our reports.
Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm