Rich Text Fields

I am trying to produce a report using MS SQL Server Reporting Services that
will include data that is stored as Rich Text Format.
If I use a regular TextBox, Reporting Services displays all of the RTF
escape codes around the text.
Do you know of a way to get the text out of a Rich Text Field within either
a SQL Server stored procedure or through an add-in to Reporting Services?Reporting Services currently does not support rich text. The best you can do
at the moment is to write some code to convert the rich text to plain text.
Support for rich text is a high priority for the next version (the version
after SQL Server 2005.)
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"TroyS" <troy.stauber@.ilg.com> wrote in message
news:eStQoWnRFHA.4068@.TK2MSFTNGP10.phx.gbl...
>I am trying to produce a report using MS SQL Server Reporting Services that
>will include data that is stored as Rich Text Format.
> If I use a regular TextBox, Reporting Services displays all of the RTF
> escape codes around the text.
> Do you know of a way to get the text out of a Rich Text Field within
> either a SQL Server stored procedure or through an add-in to Reporting
> Services?
>|||thanks for that info...
"Rajeev Karunakaran" <rajeevkarunakaran@.online.microsoft.com> wrote in
message news:uC9X%23gpRFHA.1096@.tk2msftngp13.phx.gbl...
> Reporting Services currently does not support rich text. The best you can
> do at the moment is to write some code to convert the rich text to plain
> text. Support for rich text is a high priority for the next version (the
> version after SQL Server 2005.)
> --
> Rajeev Karunakaran [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "TroyS" <troy.stauber@.ilg.com> wrote in message
> news:eStQoWnRFHA.4068@.TK2MSFTNGP10.phx.gbl...
>>I am trying to produce a report using MS SQL Server Reporting Services
>>that will include data that is stored as Rich Text Format.
>> If I use a regular TextBox, Reporting Services displays all of the RTF
>> escape codes around the text.
>> Do you know of a way to get the text out of a Rich Text Field within
>> either a SQL Server stored procedure or through an add-in to Reporting
>> Services?
>