HTML-markup in custom-report-Templates

[BenediktRothe]

Hi

How to use notes with HTML-markup in custom-report-Templates?

In an Custrom-Report-Fragment I use in "Custom Query" the "Custom SQL"-Option an select
  SELECT t.Name, t.Note from t_object t where  t.Stereotype = 'ArchiMate_BusinessProcess' and Package_ID = #PACKAGEID#

With "Insert Custom Field" I add the field "Note".

EA generates a textfield and does no interpret HTML-markup. It creates text like "<p level="0">xxxx</p>

Any suggestions?
Benedikt

[Geert Bellekens]

You'll have to a make it a document script fragment, and convert your HTML to RTF and return that.

I'm sure there are libraries out there that that you can use to do the conversion (Use MS Word if you can't find a better alternative). I don't think the Repository.GetFormatFromField, or GetFieldFromFormat operation will help in this case.

Geert

[BenediktRothe]

Mmh ... ok ... what a pity ...

There's a simple JavaScript-Converter: http://jsfiddle.net/JamesMGreene/2b6Lc
Maybe this is good enough ...

At least I know a direction - thanks
Benedikt

You'll have to ...  convert your HTML to RTF...

[Eve]

If you return a column name ending with .Formatted or -Formatted then the report engine with insert the appropriate formatted text.

See http://sparxsystems.com/enterprise_architect_user_guide/13.0/model_publishing/custom_sql_fragments.html