Going to the next page take a long time

rbuser

I have created a report that loads fine and going from page one to page
two only takes a couple of seconds but when I go from page two to page
three it takes close to 6 minutes and about 9 minutes to go from page
three to page four. I have placed breakpoints on any calculation that I
am doing and they are done long before the page is displayed. Does anyone
know what the problem might be?



--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Stef,

Which version of ReportBuilder are you using? Version 10.08 introduced
numerous enhancements allowing certain reports to run more effiently.

How is your data being accessed? Over a network? Are your tables indexed?
How big are the datasets you are accessing? What do your reports consist
of? (images, RichTexts, or primarily text).

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

you could make it a 2 pass report so that the whole report is generated,
then movign between pages will be quite quick (though creating the initial
report will take a while).

Another option is to print the reoprt to the archive format and then view
that in your application.

Ed Dressel
Team DM

rbuser

Thank you for the suggestion but I have actually figured out that my
problem had to do with the way I was writing my queries for the report. I
had a subreport that the master query was not being filtered enough and
was having to look through the sublink query more then necessary and that
was slowing the report generation down.

Thank you for your help and time.



--- posted by geoForum on http://delphi.newswhat.com