HTML ENCODE Report table data

Brenden Kehren asked on November 13, 2014 20:00

I need to htmlencode some report data displayed in table format using the Reporting Application. Aside from modifying the base controls used for the report, how else can I do this?

v8 htmlencode reporting

Correct Answer

Jim Spillane answered on November 14, 2014 02:08

Try doing it in the query...

(SELECT FIELD_NAME AS [text()] FOR XML PATH('')) AS FIELD_NAME_HtmlENcoded

0 votesVote for this answer Unmark Correct answer

Recent Answers

Brenden Kehren answered on November 16, 2014 20:14

Also found you can use the macro when you place the table in the report

%%report.code.name|(htmlencode)true%%

Bad part is you can't view it in the Admin interface with that option.

1 votesVote for this answer Mark as a Correct answer