Creating reports and dashboards | Stimulsoft community forum

Hi,

We have a field in application, which accepts text from User. User has the ability to input Rich text in it. Issue arises when the report is exported to pdf format. The value of this text appears blurred and comes out as an an image.

Currently we are using following code to convert this into plain text but then the formatting is lost in this case:

REPLACE(REPLACE(TRIM( REGEXP_REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(COMMENT,CHAR(9), " "),'<p','</P'),'<P','</P'),'</p>','</P>'),'</P>',(char(10))),'<[^>]*>','')),concat('&', 'lt;'),'<'),concat('&', 'gt;'),'>')

Is there any workaround this?

Hello.

Could you specify the component that you are using?
What version?
Do you use RichText or text with HTML?
Please, send us a sample of such text.

Thank you.

Hi,

I have attached mrt and its output for your reference.

Text in database column for comment under Notes is as below:

<TEXTFORMAT LEADING="2"><P ALIGN="LEFT"><FONT FACE="Arial" SIZE="12" COLOR="#000000" LETTERSPACING="0" KERNING="0"><B>GOBO</B> quoted @ $1,800 excl gst and advised client that they will need to provide a high res image for this at least <I>4 weeks </I>prior to the event.</FONT></P></TEXTFORMAT>

Stimulsoft version used (as per mrt): 2012.3.1500
I am not sure of the component used in the application, as I don't have the flex application installed.

Please let me know, if this information is enough for you.

Hello.

As we see you are using the Reports.Fx for Flex product.
The test with HTML is exported as image due to technical restrictions.

Thank you.