Richtext Printing

[hannec]

Hi,

i am using a richtext object in a form. Th data is stored in a SQL Server database. Now, i have to make a report with this data. How can i put this richtext format in a report?

Thanks
Hannec (VFP9)

 

[Mike Lewis]

You need to add a Picture/OLE Object control to the report. Then use its Properties dialogue to point it to your RTF text.

For more information, look at the topic "How to: Add Pictures to Reports" in the Help (I know you are not adding a picture, but the principles are the same).

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[hannec]

Mike,

thanks for your help.
The data is stored in a table in SQL server in a text field. But for the report i need a picture/OLE object. I don't know how to get further. Do you have any suggestions?

Thanks a lot.

Hannec

 

[Mike Lewis]

Hannec,

Just read the SQL Server table in the usual way, that is, with a remote view, SQL pass-through, or a cursoradapter -- whichever method you normally use.

The rich text will end up in a memo field. You can either bind that directly to the control within the report. Or, use STRTOFILE() to save it as a separate file.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk