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 MillerHello 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
"Rob Miller" <robert.miller@.acoa-apeca.gc.ca> wrote in message
news:uu9XXm0wEHA.3824@.TK2MSFTNGP15.phx.gbl...
> 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
>|||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
"Peter Blackburn (www.sqlreportingservice" wrote:
> 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
>
>
> "Rob Miller" <robert.miller@.acoa-apeca.gc.ca> wrote in message
> news:uu9XXm0wEHA.3824@.TK2MSFTNGP15.phx.gbl...
> > 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
> >
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment