Displaying Rich Text in Jaspersoft Reports

[Paul Schofield]

The client has added some custom attributes to the OOTB Status Report of type "Large String - Rich Text" and others of type "String". The latter are fine when pulled into a JS report, but the former are not.

On screen in Clarity a field that has a single line of text, for example, "This is some text" is stored in the database  as

<p>This is some text</p><Plain-text>This is some text</Plain-text>

If I ask Jaspersoft to use RTF when I set up the field in the report I see nothing. If I ask it to use HTML I see

This is some text

This is some text

If I don't use anything I see

<p>This is some text</p><Plain-text>This is some text</Plain-text>

Is it possible to display the text correctly in a JS report?

As always, all suggestions gratefully received.

[Nirbhay Kumar]

Hello Paul

In the query you can use this function in the query : cmn_get_plain_text_fct(<attribute>)

This will give just the plain text from the RTF field.

[Paul Schofield]

Hi there,

Thanks for this, but they set these fields up so they could see things like underline and bold and perhaps boxes. 

I'm coming to the conclusion that it's not possible to see this formatting in JS even though it looks like it should be.

[Nirbhay Kumar]

I tried with Markup = HTML on the text box, and even though underline and Italic came through but Bold was lost .. also a table was removed too.. So, yes you are right it doesn't support formatting completely.