Re: Print speed using Report Builder

From: A. Robert Thompson (robert.thompson_at_jebcointernational.com)
Date: 08/02/04 

Date: Mon, 2 Aug 2004 11:06:55 -0400

Hi Ed, I think you are right, it is a double pass report whereas the 2000
page job is not. Also, the 2000 page job is not duplex. No sub report band.

We use 'page x of y' on the bottom of every page in the slow job - I guess
this makes it a double pass.

Thanks,

Rob.

"Ed Blanchard" <edwardb@NONOsgci.com> wrote in message
news:410c2df6$1@newsgroups.borland.com...
> >
> >
> > > It now takes over 2 hours to print less than 3000 pages using an HP
> > > 4300 duplex printer. Note: to avoid confusion, this means less than
> > > 1500 sheets of paper.
> > >
> > > The printer is always 'waiting' for pages to be sent. We us the same
> > printer
> > > to print out mont end customer statements and it takes under an
> > > hour to print 2000 individual pages.
> >
> > And what do you use to print these 2000 pages in under an hour?
> > Report Builder or some other tool? If some other tool then why not
> > use that for all of your reports? If it is Report Builder then I
> > would suggest that it isn't Report Builder which is the bottleneck
> > and maybe it is your SQL.
>
> These 2000 individual pages - are they printed duplex as well? If these
> are both Report Bulder reports, what happens if you just print to
> screen and jump to page 2000? Are these reports both single-pass or is
> the long one a dual-pass? Are you using a sub report band in the slow
> report?
>
> Cheers,
> EdB