cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Hope this helps.

Former Member
0 Kudos

I failed to mention that I do have the text fields set up to display as HTML, but thanks for answering.

Former Member
0 Kudos

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

Answers (0)