First page performance
I have a similar issue as the "report performance" message from 2005-05-
19...
D7E, RB7 (fully patched).
I perform a bunch of queries tied to live SQL dataset, then summarize the
data in a "memory only" CDS (not bound to DSP). I set indexfieldnames on
the CDS, do a cds.first, then dynamically create a form that has the
actual TppReport with typical setup of:
datamodule.cds - datamodule.ds - repForm.ppDBPipeline - repForm.ppReport
There is only one record in the CDS.
When I call ppReport1.Print, the standard report window appears, and a
message in status bar indicates "Calculating Page 1 for Report Report" -
it will sit there for 3-5 seconds then report data appears.
Is this normal behavior? If so is there a way to initialize report prior
to report window appearing. If not, any hint as to what it might be?
Cheers,
EdB
19...
D7E, RB7 (fully patched).
I perform a bunch of queries tied to live SQL dataset, then summarize the
data in a "memory only" CDS (not bound to DSP). I set indexfieldnames on
the CDS, do a cds.first, then dynamically create a form that has the
actual TppReport with typical setup of:
datamodule.cds - datamodule.ds - repForm.ppDBPipeline - repForm.ppReport
There is only one record in the CDS.
When I call ppReport1.Print, the standard report window appears, and a
message in status bar indicates "Calculating Page 1 for Report Report" -
it will sit there for 3-5 seconds then report data appears.
Is this normal behavior? If so is there a way to initialize report prior
to report window appearing. If not, any hint as to what it might be?
Cheers,
EdB
This discussion has been closed.
Comments
A number of items can contribute to the load time of a page in ReportBuilder
including data access, multiple complex calculations and image rendering.
Most times the bottle neck is with data access from your database or over a
network.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
creating form/report - AND local to the workstation running the report...
I guess data access and network can be eliminated .
I ran with a number of records - first page takes 3-5 seconds, all
following pages show up after about 1/2 second. Does this help narrow
down where I can look to improve this? What about data settings within
the report - if I've set the pipeline property, is there any chance that
when report gets created it still tries to connect to something until a
timeout occurs?
Thanks,
EdB
In article <428e1a13$1@dm500.>, "Nico Cizik \(Digital Metaphors\)"
What type of data are you retrieving from your database? Which database are
you using? How are you connecting to this data? All ReportBuilder does is
retrieve a record from the connected dataset and spits it out on paper or on
screen. What does each page in your report consist of?
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com