>Hi,
>
>I was wondering as to how you would design a report that would show content of files (not VFP DB). Here is the example.
>The drive where the VFP app resides has a folder containing files, some JPEG, some PDF, and some even Excel. But mostly I am concerned with JPEG and PDF. Or maybe even just JPEG if this is the only way it can be done.
>Records of a VFP app table (or SQL Server table) have the name of the JPEG and PDF files. I want the report to print/display a line with values from the record of the DB and then, below, the image (being JPEG or PDF). The actual size of each JPEG would be different.
>How would the report to show these JPEG or/and PDF so that they can be preview (or printed)?
Dimitry,
To print a JPG/JPEG or a PDF is two different kind of things.
1)for JPG/JPEG, BMP or PNG (any 'image' file)
Try this approach:
construct a cursor with relevant fields and a field which contains the fullpath of the files you would to print
in your report you can list the fields and you can print the 'image' files the usual way.
2)for PDF
construct a cursor with relevant fields and a field which contains the fullpath of the PDF files
in your report you can list the fields.
To print the PDF files you will have to either shellexecute(yourPDFfile) or implent a activeX.
If not clear please report back for further assistance
Regards,
Koen