Text Formatting 2

[Dttrue]

Hi All,
All I wanted to do is fromat a part of a String .
I have a formula field, which is combination of Data base fields and Free text . And I wanted to Bold a part of the String . How do I do it. I am using Crystal reports 8.5
Thanks in advance .

 

[goranm]

Hi !

You can use Text interpretation.

In your formula you write something like this:

&quot;<B>&quot; + 'Your Free Text' + &quot;</B>&quot; + ' ' + {YourDataBaseField}

(If the field is numeric you must use the ToText function for the field.)

Now, wright click your field and &quot;Format Field&quot;.
There you choose the &quot;Paragraph Formatting&quot; tab and
in the &quot;Text interpretation&quot; you choose &quot;HTML Text&quot;.

/Goran

 

[Dttrue]

Hi Goran, thanks for Your help.
WHen I change the text interpretation to HTML, I loose the font . To be specific, I have Text box displaying &quot;Name&quot; in Verdana font 11. And set the same font for the Database filed with Text interpretation as HTML. This is making the 2 fields look different font size . Hope I am clear.

Thanks & regards

rk

 

[goranm]

Hi !

Yes I know that that can be a problem.

Try this workaround.

Instead of a Text box you create a formula just
with the text &quot;Name&quot; in it.

After that you change the text interpretation to HTML for that formula field, and I think you will get the same size as for your Database field.

Let me know if it won´t help.

/Goran

 

[Dttrue]

Hi Goran, thanks for Yur reply.
I have got a work around for it. I made a mutli line text box , and inserted the data base fileds where ever I wanted and Highlight the Filed and set the desired format.

Regs.

 

[rosemaryl]

Dear Dttrue:

In the formula you can set the font face and size as such:

&quot;<B> <font face = verdana> <font size = 1&quot; + 'Your Free Text' + &quot;</B>&quot; + ' ' + {YourDataBaseField}

//1 is fairly small

Change the numbers from 1 - 8 until you find a match...

Hope that helps, ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[Dttrue]

HI rosemaryl (MIS) , & goranm ,
Thanks for your help in the past.I have a similar problem now, this time I am trying to make a part of text as Hyper link. I have crated a formula filed , with the following

&quot;<A HREF=&quot; + &quot;

http://www.Yahoo.com&quot;

+ &quot;>Yahoo </A>&quot;

Included the formula field in the Text object along with the Text , and changed the Text interpretation to HTML , and it doesn't work. Please help ..

Thanks & regards

rk

 

[rosemaryl]

Dear Dttrue,

Just saw your post... I have been out of touch for a little bit. Let me research this for you and I will post back with my findings....

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[rosemaryl]

Dear Dttrue,

Is the end result that you need text (data from a field or formula) to link to one website or are you trying to build the url on the fly?

There is the feature that you can right-click on any field and choose Insert Hyperlink. Have you looked at that? Does that meet your needs?

You can use the formula button (x-2) to build a formula that is based on database or formula fields in the report.

Ro
Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[SpiderBear6]

I don't get the HTML text appearing in my drop down... did I not install something?

 

[rosemaryl]

Dear SpiderBear6,

You must select a field or formula that is the type of text. Click format field, paragraph formatting tab. You should then see the item, Text Interpretation from which you can choose HTML Text, RTF, or plain text.

Regards,

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[SpiderBear6]

I'm using Crystal Reports .Net which doesn't support HTML text and as far as I can tell has RTF Text in the drop down but it doesn't actually work. (A bug me thinks)

 

[rosemaryl]

Dear Spiderbear,

My apologies. I only read the last thread item instead of all the preceding ones and missed that.

You are correct that html text formatting is not available for .net.

See the following link:

http://support.crystaldecisions.com/library/kbase/articles/c2011631.asp

regards,

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[SpiderBear6]

No need to apologise Rosemary. Here's a star for trying to help.

I found a way to get bolding to work by using formulas and some rtf tags.

Cheers.