Page 1 of 1

Report Designer: format HTML fields correctly

Posted: Mon 29 Dec 2014 10:47
by willswing77
Hi!
I have a field in my MySQL DB of the type <MEDIUMTEXT>. This field contains normal text with some simple HTML format tags like <<p>> or <<&auml;>> or <<span>> etc.
When I put this field on my dbForge Studio Report I can not tell the Report Designer to interpret these tags. When I export the report to either PDF or HTML the tags are shown as tags rather than interpreted by the Browser or PDF reader. In addition: the preview function of report designer shows only the tags instead of the formatted text.
Thanks for any suggestions!

Re: Report Designer: format HTML fields correctly

Posted: Tue 30 Dec 2014 17:06
by alexa
Please use the 'Rich Text' control available in the 'Toolbox' tool window that can be invoked from the 'Data Report' toolbar.

Once the 'Rich Text' control has been added onto your report, please set the focus on this control, navigate to the 'Properties' window, expand the 'Data Bindings -> HTML' section and select your column containing HTML code against the 'Binding' property.

Re: Report Designer: format HTML fields correctly

Posted: Tue 30 Dec 2014 21:04
by willswing77
Thanks, Alexa! That helped. :P
The feature you described is well hidden in the properties box :wink:
Happy new Year!

Re: Report Designer: format HTML fields correctly

Posted: Wed 31 Dec 2014 13:54
by alexa
A Happy New Year to you too. Please let us know if any questions arise.