Displaying hyperlinks in answers.solution reports

Content

Hi All,

I would like to generate a report that contains a list of all our organisation's answers, including answer ID, product hierarchy, and answer solutions.

I'm having trouble with the answer solutions field. In some of our answers there are a mix of hyperlink, image, and text. How could I get the report to display all this in an easily readable format and export it?

Ideally I'd like the answer solution section to be in the same layout as how the article is displayed in our customer portal.

When formatting this column, if I don't select "strip html" for this field, it displays the text however isn't very easy to read. If I select "strip html", it removes the script and therefore we cannot easily identify the hyperlinks.