>>>>>Do you have anything to say on the topic of the printing blob fields?
>>>>>
>>>>>We're storing data in SQL Server and I retrieve them as blob fields. Now I want to print a report with these fields. I did create a workaround (since I only needed to print 1 row), but I am wondering if SET REPORTBEHAVIOR 90 is the requirement for the above code to work correctly?
>>>>>
>>>>>The code works fine in Preview, but doesn't print when I use CutePDF as a printer. I am using ReportBehavior 80.
>>>>Naomi,
>>>>It is just that I have had very very bad experience with BLOB fields and I was just wondering why you use them.
>>>>
>>>>The above code by Lisa only works with reportlistener.vcx and therefore with Reportbehavior 90.
>>>>Set RB to 90, if it works fine in preview print it with a normal printer first. If that's ok and it does not print with CutePDF, you know whom to blame.
>>>>Good luck
>>>>Regards,
>>>>Koen
>>>
>>>I was hoping someone else tried that code and can tell me if it works with RB80 or with RB90 it works for any printer. I already implemented a workaround, but I'll try a quick test myself now with RB90 and CutePDF.
>>>
>>>UPDATE. I tested with RB 90 and it worked with CutePDF.
>>
>>Naomi,
>>
>>good to learn you have found the solution. So change to ReportBehavior 90 global in your application.
>>There is, as far as I know nothing at all against using RB90 setting with reports made and constructed with RB80. Works, again my experience, smoothly.
>>The otherway around, obviously, not.
>>
>>Regards,
>>
>>Koen
>>
>>P.S. Don't forget to implent the report**.app in your application or even easier, implent Cesars' RepportPreviewer.app (almost free of charge)
>
>I can not switch to RB 90 as we found many problems using RB 90. I also don't remember what was the solution (if any) I implemented then.

The only problem I have encountered with RB90 is that you may have to expand some of the fields, especially the numeric. I fear that my "direct" approach may not work with RB 80, but I am not sure about that.

NB! Make sure to incorporate the latest patches to RB 90. And don't forget FoxyPreviewer which is much better than the one that ships with VFP. Maybe it will solve ALL your problems? Worth a try.