Removing HTML from the text in report server 2005

You could strip it out at the database level.

I've come across a script which I've used as a User Defined Function in SQL Server which strips out all the HTML code, just leaving the text. The problem is that you want to leave some formatting e.g CR so you don't get the text all on one line.

What you could do is create a calculated column in the table which uses the UDF or update the Un-formatted filed using a trigger. Then just point the report to this un-formatted field.

I'll post the code when I get to work in the morning.

I'm not saying this is particularly fast way of doing this.

SPP at 2007-10-8 >