|
Dean,
I may be in a position to suggest a solution for
your problem involving image control based report with large number
of images (say in hundreds). You don't have to use OLE type controls
at all. Stored paths to image files is considered the preferred way.
On opening the report in print-preview, loading of
images takes place only for the first page. Thereafter, images on each page
get loaded progressively, as you step through the pages.
Could you please confirm whether your report works
smoothly if you take care to wait sufficiently at each page (for the
display to get properly stabilized), before moving to the next page ? If this is
the case, I might be in a position to give a programmatic solution. With
that you should never again face a problem, even while stepping through the
report pages in a brisk manner.
Best wishes,
A.D.Tejpal
----- Original Message -----
Sent: Monday, October 03, 2005
00:31
Subject: [AccessDevelopers] Re:
Formatting Report...
Thanks for considering my question A.D., I have long seen that
you
are extremely helpful in these matters. I did actually get my report
to work. It was something trivial that escapes me at the moment, a
formatting setting in the detail section or something that when I
changed it, voila all was well.
But, while I have your attention,
perhaps you have a suggestion for
my app. This is the second time I
ventured into making reports with
large numbers of pictures and I am
surprised to find it as difficult
as I do. I have always read that it is
not a good idea to save the
picture, just the path. I first did that,
assigning the pictures at
run time to an image control on a form. It
worked like a charm.
When I went to make a report that turned out to be 53
pages with 80
pictures I found it very difficult to get those pictures
into the
report. I used an image control again, assigned the picture in
the "on format" event of the detail section. It was slow, but
worked.
It worked that is until the number of pictures increased to
a point that I
must have run out of memory or something and
everything broke down.
I
went back and used a OLE field to store all the pictures and was
able to
then make my report using a bound object frame, it worked
well enough. Of
course now my database is ballooned up over a
gigabyte and it has only
produced one report on one project. If I
want to use it as an application
for some time to come, that
obviously won't do.
I've now started
experimenting with saving only the path, then
creating a temporary table
at report run time, with all the pictures
in an OLE field. I figure I can
create the report off the temp
table, then delete that table when the
report is closed.
My question to you is, does this have to be that
complicated? Am I
missing something simple and making too much of it? Has
nobody ever
had to make reports with numerous pictures? It seems an
obvious
application of data storage. I have numerous projects with
numerous
issues and these issues may or may not have pictures associated
with
them. I am making reports where issues are printed along with
related information, calculations and pictures if they exist.
I
look forward to any input you or anyone else may have on the
topic.
Regards,
Dean Davids
--- In [email protected],
"A.D.Tejpal" <[EMAIL PROTECTED]...>
wrote:
>
Dean,
>
> You could consider uploading a
zipped version of your db (with
some sample data) to Files section of this
group.
>
> Best wishes,
> A.D.Tejpal
>
> ----- Original Message -----
> From:
dsdavids
> To: [email protected]
> Sent: Monday, September 26, 2005
05:45
> Subject: [AccessDevelopers] Formatting
Report...
>
>
> I have a report with 2
subreports in detail section and one
group
> header.
The report runs fine until I change the group header to
repeat section. I
want the group info printed at the top of each
page as each group has 10
or more pages.
> With repeat section enabled the status bar
reads "formatting
report, press ctl break to cancel" indefinitely and the
preview pane
never displays the result. I do have to press ctl break and
stop it
as I've left if for hours with no results.
> Any
reason this might be happening? This is AccessXP database.
>
> Thanks for any suggestions.
>
Dean
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
|
