Slow preview report in Network

[Lengliz]

Hello,

Too long waiting time problem before preview my report in my computer and network (nearly 5 minute when I execute my report on a distant computer with 2Mo ADSL).
The report permits to display some photos, it is based on a general field using APPEND GENERAL to populate myTable with photos.
myTable contains 2000 photos in a General field the size of this table is :

- mytTble.dbf = 77 ko
- myTable.cdx = 79 ko
- myTable.fpt = 1 700 000 ko

I want to know there are a means to improve the time of waiting so that the state is displayed more quickly

I found a good solution in thread1252-1253112 written by TheManiac it work's fine for forms but for report i haven't anderstand how to do.
The idea of TheManaic in this thread was very good because it's better to avoid to use General field and proroblem of OLE corruption.

Thank you
Mistral

 

[Mike Gagnon]

If you decide to store your pictures seperatly (which is highly recommend), in your report, where you have your image control, instead of pointing to a general field, change that you point to the "image file name" (complete path or relative path is required).

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)

 

[Lengliz]

Mike,

I tried this but when i write the path or using a program i have error message: Path not found, but when i copy and past the path it work's fine ( ctrl C and ctrl V).

so i thought to use this methode and it work's fine:

my table contain a field named <path> where i write the path of the photo.jpg (eg. c:\photo\photo1.jpg):

MyPhoto="c:\photo\photo1"+".JPG"
REPLACE PATH WITH LOCFILE(MyPhoto,"JPG")

Thank's
Mistral