Alright, I couldn't wait so I went ahead and whipped up a little rough trial. Moving the code to the "On Print" of the detail section of the subreport works with no issues. Just a quick progress bar each time the page is changed. Quite acceptable. I can now delete all those OLE objects and I'll have a much more efficient setup that will serve my purpose nicely. Thanks again for your help.
Dean --- In [email protected], "dsdavids" <[EMAIL PROTECTED]> wrote: > Well that makes perfect sense. I imagine then, that there may be > some questions on account of the pictures are in one of two > subreports in the detail section of a main report. The print event > where I put the code may be in the subreport or in the main report > and then referring to the controls in the subreport. You've > certainly sent me on the right path. I'm sure with a bit of > experimentation I'll get it. I'm not able to work on it right now, > but I'll let you know how it turns out. > Thanks again for your time, hope to return the favor some day. > Dean > > --- In [email protected], "A.D.Tejpal" <[EMAIL PROTECTED]> > wrote: > > Dean, > > > > Apparently you are using the format event of detail section > for loading the images. This imposes enormous additional overhead as > normally there are two or more cycles of formatting involved. When > you have a calculated control on the report, with [Pages] as part of > the expression, there is a preliminary cycle of formatting stepping > through all the pages, right till the last one. > > > > This is followed by one or more rounds of formatting for each > record, before corresponding print events. Only then does the first > page get displayed in print preview. > > > > Typically, print event fires only once for each record. When > the report opens in print preview, the print events pertaining only > to the first page take place. > > > > Kindly move your code (for loading the images) from format to > print event of detail section and then confirm whether the report > performs smoothly when stepping through the pages very slowly. > > > > Best wishes, > > A.D.Tejpal > > > > ----- Original Message ----- > > From: dsdavids > > To: [email protected] > > Sent: Monday, October 03, 2005 15:18 > > Subject: [AccessDevelopers] Re: Formatting Report... > > > > > > 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. > > With a small number of pictures this was working. There was a > delay at the start up, and at each page forward, but it did work. > > If there is a way to stop all that preprocessing, I would say > this > > will be the solution I am looking for. I am very interested to > see > > an example of the code you mentioned. > > > > Thank you. > > Dean > > > > --- In [email protected], "A.D.Tejpal" > <[EMAIL PROTECTED]> > > wrote: > > > > > 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 ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
