HTML Contents in Crystal Reports

[aspengal]

In our .net application, we have a Rich Text box and this uses HTML to perform formatting and it is stored in sql server in a HTML format(text field with HTML tags)

My question is , in a crystal report that prints this data, is it possible to display this HTML content? I tried a few ways and the HTML tag itself is coming in the report and it doesn’t look very good.

One of the alternative is to strip out the html tags in the data before displaying it in Crystal report but we are loose the format.Is there anyway to strip out this HTML tag so that I get a word like formatting? Any idea as how to display HTML content in Crystal Reports without loosing the format.

Regards,

 

[Turkbear]

Hi,
Right-Click on the field and under 'Paragraph Formatting'
select HTML as the text interpretation...

 

[aspengal]

Thanks a lot..But I do not see a 'TEXT INTERPRETATION' in the Paragraph option. Why am I not able to see it in my RIght Click/Format Option.I see evrything else like RIght, LEFt, etc etc etc...PLs. help.

 

[Turkbear]

Hi,
Right-Click - 'Format Field' should produce a tabbed set of options, one of which is 'Paragraph Formatting'

If it is a formula field,I'm not sure that it is an option, but for any standard database text field it should be there, right below the 'Reading Order' section in CR10 and 'Line Spacing' in CR8.5.

I have checked it in both CR8.5 and CR10

 

[aspengal]

THanks a lot for the reply. I created a database object which had a field called : 'testing' which had a text data as :
<title>Business Objects:Crystal Enterprise - HTML Contents in Crystal

In Crystal Reports when I inserted this field 'testing' and did a Paragraph Text Interpretation as : HTML, It should format the html syntax :
<title>Business Objects:Crystal Enterprise - HTML Contents in Crystal.

Instead it shows the field as it is as with the HTML Tags. :<title>Business Objects:Crystal Enterprise - HTML Contents in Crystal.

Pls. Help

 

[aspengal]

Ok, I understand that there are only some HTML tags that I can use in Crystal reports. What abt the remaining?

eg., I have a HTML tag as &alt;STRONG;&ALT what happens to such syntax???

 

[Turkbear]

I do not know of a list anywhere, it may be trial and error to find out..
( I tested <H3> and <b> and they both work)

 

[Turkbear]

Hi,
OK, so there is a list...( I need to look first, post later)
From CR10's Help :

---------------------------------------
The supported HTML tags are:

html
body
div (causes a paragraph break)
tr (causes only a paragraph break; does not preserve column structure of a table)
span
font
p (causes a paragraph break)
br (causes a paragraph break)
h1 (causes a paragraph break, makes the font bold & twice default size)
h2 (causes a paragraph break, makes the font bold & 1.5 times default size)
h3 (causes a paragraph break, makes the font bold & 9/8 default size)
h4 (causes a paragraph break, makes the font bold)
h5 (causes a paragraph break, makes the font bold & 5/6 default size)
h6 (causes a paragraph break, makes the font bold & 5/8 default size)
center
big (increases font size by 2 points)
small (decreases font size by 2 points if it's 8 points or larger)
b
i
s
strike
u

The supported attributes are:

align
face
size
color
style
font-family
font-size
font-style
font-weight
--------------------------------------------