Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP6 - Displaying Pictures on Reports
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00223941
Message ID:
00225798
Views:
11
>Now, i have followed the instructions that was stated about not storing the picture in the table... (general field bloat concern) and stored a backlink to the picture file.
>
>Then to display it on the form, I just change the image.picture property. Work's terrific.
>
>Thanks...
>
>Now, this picture, I need to print it on a report. How do I do this?
>
>I tried the following:
>1. Create a cursor to hold the results of the query for the report. One of the fields in it is called pic. It is of general format.
>2. Run the query.
>3. Scan through the query, replacing the general field contents with this line:
>append general pic from (m.picture)
>where m.picture is the name of the field in the table mentioned above.
>(it contains the full name and path to the specified picture file)
>
>Results:
>1. 256 Colour bitmap. Shows on report but has no definition and is hard to view.
>2. As a jpeg. Doesn't even show on the report. Only a little box with the filename in it does.
>
>What piece of the puzzle am I still missing?
>
>I really would like to store the image as a jpeg and print te jpeg. If worse came to worse, I could do it via a bitmap, however it still needs to print with better quality.
>
>TIA,
>Mike

First, select "From File" for the picture properties on the report. Put an expression like (hcfindphoto(id)) in the file box and write a function to lookup the filename and fill this "on the fly".

Hope this helps.

Pete
Previous
Reply
Map
View

Click here to load this message in the networking platform