Geek Answers Handbook

Crystal Report showing HTML text but no bullets are displayed. What for?

I get data from the nvarchar (3000) SQL-Server field, which is formatted as html, displaying it in Crystal Reports 11. The data is saved as bullets, and if I pull out the data and drop it in a text file with the html extension, it shows the bullets. But from Crystal this is not so. I get a new line, but not bullets.

The saved field is as follows:

<HTML><BODY><DIV STYLE="text-align:Left;font-family:Tahoma;font-style:normal;font-weight:normal;font-size:11;color:#000000;"><DIV><DIV><P><SPAN>This is a bulleted list</SPAN></P><UL><LI><P><SPAN>One</SPAN></P></LI><LI><P><SPAN>Two</SPAN></P></LI><LI><P><SPAN>Three</SPAN></P></LI></UL><P><SPAN /></P></DIV></DIV></DIV></BODY></HTML>

And in Crystal, it looks like this:

 This is a bulleted list One Two Three

In other words, no bullets. Why not?

+7
html formatting sql-server-2008 crystal-reports
source share
1 answer

For some reason, Crystal Reports only supports a subset of HTML tags. According to this forum topic , bullets are not one of them.

For posterity, here is a list of supported HTML tags:

 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 8 points or larger) b i s strike u
+6
source share

More articles:


All Articles