Unanswered: server.htmlencode in sql store procedure?
hi, i save some text into my database which looks like this..
<li><strong>adfadsf as </strong>
<li><strong>asf as </strong>
<li><strong>df sad </strong>
<li><strong>f as</strong> </li>
how m i gg to display them as numbered list in my report?
i'm using store procedure to retrieve them out into pdf format..
If you are only allowing basic formatting, you should consider storing your data formatted as rtf in text datatypes.
I certainly would refrain from storing data as html in a database unless that data was intended to be displayed in a browser.
Regardless, this is what we refer to as a "presentation" issues. How the data is displayed has nothing to do with the database server, and is completely up to the reporting software. So you will need to find out whether Crystal Reports can display html code, and can convert it to a numbered list. Check the Crystal help system or post your question in the Crystal Reports forum, but I would not count on finding a simple solution to this.
If it's not practically useful, then it's practically useless.