sql server reporting services: Can I render RTF data into a SQL Reports Textbox? -- sql server reporting services

You're in the

sql server reporting services

group:

Can I render RTF data into a SQL Reports Textbox?

Rob Miller
11/5/2004 11:10:28 AM

sql server reporting services:

We've got some form letters that are stored as RTF encoded text fields in
the database. We'd like to include this info into a SQL report. Any one
know if this is do-able, while still maintaining the RTF formatting in the
output?

I think the answer is no, but I wanted to throw it out there anyway.

Regards,
Rob Miller

Re: Can I render RTF data into a SQL Reports Textbox?

Peter Blackburn (www.sqlreportingservices.net)
11/6/2004 5:48:34 AM

Hello Rob,

It is not possible to render into a TextBox . BUT there is a solution....

Create a Custom Assembly into which you create a function which takes in
your RTF encoded field, and returns an image stream and bind that to an
Image Control.

Inside your function, you create a graphics object, and instatiate an RTF
Textbox on it - putting the RTF data in. Then you extract an image of the
drawn grpahics object and output that.

I realise that it is a bit cludgy but it works.

Peter Blackburn
Author: Hitchhiker's Guide to SQL Server Reporting Services
http://www.sqlreportingservices.net

[quoted text, click to view]

Re: Can I render RTF data into a SQL Reports Textbox?

Victor
1/7/2005 11:29:07 AM

Is there any way to include data fields in this RTF and use your method (or
any other method to automatically create formatted letters)?

Thanks.
Victor

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn