Report Builder 3.0 - Display RTF db fields as RTF text

Hi

I'm using MS SQL Server Report Builder 3.0 and have a database field that contains RTF code ('{\rtf1\ansi\deflang3081\ftnbj\uc1 ...etc...' and I'm wanting this to display as RTF text.

Any ideas on how to do this please?

The text box > placeholder properties > Markup type > 'HTML - Interpret HTML tags as styles' does NOT work for this.

T

June 21st, 2015 5:45pm

Hi Shell,

According to your description, you want to display RTF as text in Report Builder 3.0.

In SQL Server Reporting Services, we can use the custom code function to convert the RTF to TXT. In the custom code function, use the window RichTextBox control to read the RTF, and then return the TXT. For more details, please refer to the Jins reply in the following similar thread:
https://social.technet.microsoft.com/Forums/sqlserver/en-US/adada6e3-d4ab-4390-a196-ee7d1a946ef3/displaying-rtf-objects-in-ssrs-2008?forum=sqlreportingservices

Thanks,
Katherine Xiong

Free Windows Admin Tool Kit Click here and download it now
June 23rd, 2015 2:20am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics