7

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

The field that is saved looks like this:

<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?

thursdaysgeek
  • 7,696
  • 20
  • 78
  • 115
  • I don't have a lot of control over how the data is saved (app in C#.net, some sort of toolbar and text editor box). However, I edited the data in the database, and that did not make a difference. It did still show correctly in the app, still had no bullets in Crystal. – thursdaysgeek Oct 21 '10 at 00:21