>>>>It is so easy, you'll slap yourself with the trout :)
>>>>
>>>>In the report writer, add a picture field. In properties of the picture, use the FILE entry (not the FIELD entry). In FILE, put the cursor field that holds the full path of the file (eg. tmpCursor.fullFileNameofPictureFile).
>>>
>>>Hej, I made the same, but got error 'invalid file path'.
>>>
>>>>
>>Did you get this error when designing the report, or running the report?
>
>Running on preview. I have some empty fields in table (no picture filepath stored), and what about extra spaces at the end of char fields in VFP?
In my SELECT statment I do something like:
select s.styleNum, s.description, ;
...more fields ...,;
fullPictureFileName(s.picfile) as picFile, ;
...more stuff
FullPictureFileName() prepends the full path (stored in application object) to the file name, and does trimming. Also, it makes sure that the file exists. If the field is blank, or if the file does not exist, fullPictureFileName returns oApp.noPictureFileName. In my application object, this is the full file name of a blank JPG file (or it could be a JPG file that has "NO PICTURE" on it).
Steve Gibson