CR-Formula-Field with HTML text interpretation

Hi,

how can I format a formula field so that I can use html tags?

I have found the following comments in your db (the thread reffered to VS 2003 (CR 9)):
----
04.05.2005 at 07:26AM PDT, ID: 13707522
      
GJParker:
create the formula field on the crystal report and leave it blank, and then add this as the code in your .net Code

crFormulaFieldDefinition.Text = "Replace ('This is how to===place carriage returns===in a text object','===' ,chr(13))"


04.05.2005 at 07:56AM PDT, ID: 13707855      

frodoman:
Another option is to replace the === with <BR> and make sure you've formatted the formula field to use HTML text interpretation.  The advantage to this approach is that it allows you to also use other HTML formatting tags if you want to use bold text, italics, etc.  If you have no interest in ever doing that then stick with chr(13).
----

I can only find "none" and "RTF-Text", but not "html text".

If only RTF-Text is available, what do I have to put it instead of
'Is it an <b>importand</b> or a <i>strange</i> topic?<br>...'

Best wishes and thanks in advance
Michael
mp45Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
WHere are you looking for the HTML interpretation?
You need to FORMAT the field then click the PARAGRAPH tab.

mlmcc
0
mp45Author Commented:
yes, right click on formula field - format - paragraph tab - combo 'text interpretation':
it only shows "none" and "RTF text".

I tried "RTF text" with a text containing html tags, but it doesn't work, the text shows e.g. '<b>' instead of the wished  bold text.

Best
Michael
0
mlmccCommented:
Try using \b

mlmcc
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

mp45Author Commented:
I've chosen 'rtf text' and tried "xx \byy",  "xx \b{yy}",  "xx \b(yy)" and  "xx \b yy" to make yy bold. Bold hasn't occured, rather "\b" was shown.

What is the syntax?
... for bold, italic are there even more tags?
... how can I continue without bold e.g. that zz shows normally again ("xx <b>yy</b> zz")?

Is the html text interpretation available in Visual Studio .net 2005?

Michael
0
mp45Author Commented:
I've found some hints in another thread.
"{\rtf1 normal \b bold bold \b0 normal \i italic italic \i0 normal.}"
shows the normal, bold and italic text almost as wanted.
 - 1st problem: The first word "normal" was in bold (the format of the field is not bold). So I had to add "\b0" at the beginning:
"{\rtf1 \b0 normal \b bold bold \b0 normal \i italic italic \i0 normal \b bold bold \b0 normal.}"
 - 2nd problem
The text appeared in Arial although the field format is set to Times New Roman.
How can I assure that the chosen font is used in a field with rtf text interpretation?

Is rtf text in cr always that stony?

I use Visual Studio .net 2003 (CR 9).
Is the html text interpretation available in Visual Studio .net 2005?
Which CR version goes with it?

Michael
0
mlmccCommented:
I don't know.  I have never had a real reason to use RTF interpretation.

I know the rtf and html capability in Crystal is limited.

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
simisudevanCommented:
crystal report and text interpretation in html format and <br> Tag
--------------------------------------------------------------------------------

In my crystal report <br> tag is working ,but if we are giving more than one <br> tag it is not taking
eg:
Simi <br><br><br> Sudevan
it will print
Simi
Sdevan
I want more than one line break.please help me
0
mp45Author Commented:
I guess it is a good idea to ask your question as a new question because this thread is already finished und thus the experts cannot gain any points for their answers anymore. Hints about the CR version you work with may also be of interest for the experts.

Michael
0
mlmccCommented:
I just tried it in CR XI.  I also get no blank lines.  To get the blank lines I used

Simi <br> <br> <br>Sudevan

mlmcc
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.