It's all about the answers!

Ask a question

How can I tell RPE to deliver HTML as HTML and not as Plain Text for RB Query result

Erwin Kunz (94687086) | asked Aug 30 '16, 3:10 a.m.
RPE 2.1

I've created a query with report builder to return Workitem ID, summary and description.
Exported the DTA, DSX and use both in RPE
All fine except that the description comes as plain html code.

result/result/Description is what is returned and this seems to be HTML

up to now I was used to create connection and query directly in RPE and description was
workitem/Description/_value and was plain text without HTML coding

Is there a way to tell RPE that this value is HTML and to be handle as. Or a way to transform the text

thank you

2 answers

permanent link
Subramanya Prasad Pilar (4.6k16) | answered Aug 30 '16, 8:26 a.m.
edited Aug 30 '16, 8:27 a.m.
In the template, you should use Script Expression with "XHTML Input" and "XHTML Output" options checked. You can use JavaScript to remove/replace the tags as in the screenshot.

Erwin Kunz commented Aug 30 '16, 10:55 a.m.

Thank you
I surely a solution today. But as I understood,  it will be a real rich text editor in the near future

permanent link
Erwin Kunz (94687086) | answered Aug 30 '16, 10:47 a.m.
edited Aug 30 '16, 10:51 a.m.
Hi all

I finally found the solution.

My text was like:

  cause a reset.<.br ></.br>Customer a

1) created a variable MyDescription
2) Assigned Description to MyDescription with XHTML Input not selected and XHTML Output selected
3) use MyDescription in the report

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.