How do I lose the HTML formatting in a SSRS report?

(0) Share

Report

Posted on by Ben Markland

I am using the report wizard in CRM 2013 to build a report that shows emails attached to cases along with their bodies (the description field). The issue is the report displays all the HTML code behind the formatting of the emails which makes them very difficuly to read. Is there a way to just show the emails with their native formatting or export them as plain text. See below.

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Mahadeo Matre 17,021 on at

Like (2)

Report

Hi..

To show Text / description without HTML formatting, you need to download report rdl file, and then open report into Visual studio.

Then you will see description column, remove description text box,

once you delete, it will look like

right click and Create Placeholder

Set Value = Description and Markup Type = HTML - Interpret HTML tags as styles.

Save report and Import report to CRM.

Now you can able to see text instead of HTML markup.

for more details please check

https://msdn.microsoft.com/en-us/dd207057.aspx

http://sqlblog.com/blogs/greg_low/archive/2008/08/25/displaying-html-content-in-reporting-services-2008.aspx

Hope this will help..

Was this reply helpful? Yes No
Ben Markland on at

Like (0)

Report

Thank you. Worked perfectly.

Was this reply helpful? Yes No