Method:Classic General Q&A

Re: Reporting Activity Comments without HTML

robert.cowart — Tue, 04 Nov 2014 19:24:02 GMT

The typed out code is:

Imports System.Text.RegularExpressions

Private Sub OnBeforePrint(ByVal sender As Object, ByVal e As System.Drawing.Printing.PrintEventArgs)

CType(sender, XRLabel).text = Regex.Replace(Regex.Replace(Regex.Replace(CType(sender, XRLabel).text, "<[^>]+?>", ""), " ", " "), "·", "")

End Sub

Thanks!

Re: Reporting Activity Comments without HTML

Method_Adam — Tue, 04 Nov 2014 14:43:09 GMT

Hi Robert,

Sorry about the late reply. In our CRM_Activities_WithComments report template we have code that removes the HTML for the activity comments. It can be found below:

Depending on where you are creating your report, you should be able to use a similar script to remove the HTML.

Hope this helps,

- Adam

Reporting Activity Comments without HTML

robert.cowart — Wed, 29 Oct 2014 18:14:37 GMT

Is there a way to do an HTML Sanitize function on Activity.Comments so in a report I just get the text without the HTML? We really need a way to report on text columns that have embedded html -- without the html in the pdf. PDF viewers handle the html as plain text and it looks awful. Help!!

I wrote a recursive HTML Sanitize VB.Net function for SQL Server SSIS jobs for our website but I don't see anything like it in Method.

In the meantime, I have disabled "Show in HTML editor" in my screens. Going forward the HTML will not be there. Comments previously entered may be chalk full of html. Ugh... Thanks.