How do get rid of formatting characters when reporting Issues fromreporting database

[anovak]

Issue description and Issue Resolution because they are rich text (I
guess) when reported via SQL Reporting Services contains all kinds of
garbage like </div>, &nbsp, etc.
What's the best way to strip the special characters out when reporting
from the database?

Thanks,
Andy Novak
UNT

 

[Marc Soester [MVP]]

Hi Andy,

you have a couple of options depending on your SQL version.
If you run 2008 you can use the REport builder 2.0 which by the way renders
the rich text.
If you have 2005 you will need to write some code to strip the HTML tags out.
Hope that helps