Certainly, I did try that as my first preference. It worked well
until the number of pictures increased such that it became a memory
problem. Apparently my report runs formatting through all pages first, I
assume to determine number of pages and what fits where, before settling on
the page to display.
> 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 -----
> From: dsdavids
> To:
[email protected]
> 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
