Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How Do I Display HTML Formatted Text From A Data Table In Crystal Reports?

I'm creating reports in Crystal XI. The information being displayed in the reports comes from data tables where the text is formatted in HTML.

I've worked with Crystal Reports enough to know that HTML text pulled from a data table doesn't appear in Crystal the same way it does in a web browser. Crystal Reports ignores all the tags (...unless I'm missing something...) and just displays the text.

Someone far more Crystal savy than I (...who I don't have access to...) came up with a Formula Field workaround that tricks Crystal Reports into displaying some basic HTML tags. Here's that workaround:

<!--

stringVar TableName := ;

TableName := Replace (TableName, "<ul>","<br>&nbsp;<br>");

TableName := Replace (TableName, "<li>", "<br>&nbsp;&nbsp;&nbsp;&bull;&nbsp;");

TableName := Replace (TableName, "</li>", "");

TableName := Replace (TableName, "</ul>","<br>&nbsp;<br>");

TableName := Replace (TableName, "<a", "<u><font color='blue'");

TableName := Replace (TableName, "</a>", "</font></u>");

TableName

-->

QUESTION - Does any similar workaround exist so I can display an HTML Table in Crystal Reports? If not, is there any way to display HTML formatted text from a data table in Crystal Reports as it would appear in a web browser?

replied

Hi Steven,

To display html text in Crystal Reports follows these steps.

1. Right click on the field and select Paragraph tab.

2. Under 'Text Interpretation' select 'HTML Text' and click OK.

I have tried using the way,but it never works.So reply me if there is any way to solve the issue

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question