Hi

RE:   Display RTF database field (incl its images) in SSRS report

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...' (which could contain images as well as formatted text) stored as NTEXT and I'm wanting this to display in an SSRS report.

Any ideas on how to do this please, eg: image?

Thanks

Regards

Shell

SQL Server 2012
MS SQL Server Report Builder 3.0

• Edited by shell_l_d 7 hours 47 minutes ago

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

I'm trying to display an RTF database field in the SSRS report (eg: bold, underline, paragraphs, images, etc) not just plain text.

In the link you provided, in the answer, I need more detailed info for step 2 unfortunately:

Using Report Builder 3.0, these options exist in the 'Referenes' tab:

* Add or remove assemblies:   dll name

* Add or remove classes:  Class Name    &    Instanc

Ive edited my original post slightly.