We help IT Professionals succeed at work.

Show RTF format in an SSRS report

C M
C M asked
on
728 Views
Last Modified: 2018-04-06
Hi Experts,
I would like to convert RTF data stored in sql server 2014 database to appear in an SSRS report. Previously I have stripped the rtf so that only the text appears. However I really need to find away to preserve the original formatting. Hopefully an additional plug-in or another software to convert?

An example of how it is stored in database as a 'nvarchar(max)',
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 arial;}}
\viewkind4\uc1\pard\f0\fs22 Testing 123
\par }

Many thanks,
Comment
Watch Question

Database Analyst
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
C M

Author

Commented:
Hi Icohan,

Thank you for your information and the link. This is a really good last resort but as using an image is not ideal. Then again it appears this maybe the only option. I am hoping to find some kind of ReportViewer or SSRS add on that will be able to do this. Sorry I will keep this open a little longer just in case more experts reply with another type of lead that I can investigate.
C M

Author

Commented:
Very quick response. Not exactly what I was looking for but it appears to do enough. Thanks for the link