Report Speed Goes slow on calculation
Hi,
I got good satisfactory answer for my first question. I noticed that
converted reports from the QuickReports to Report Builder are much much
slower then the Quick report.
A report in quickreport opens in 2-3 Secs. while the same report in Rbuilder
takes over 3 Minutes !
In report Builder we the calculations have been transfered to ONPrint events
either in Pascal or in Rbuilder Events as we have used the Converter tool.
Please suggest.
Thanks.
I got good satisfactory answer for my first question. I noticed that
converted reports from the QuickReports to Report Builder are much much
slower then the Quick report.
A report in quickreport opens in 2-3 Secs. while the same report in Rbuilder
takes over 3 Minutes !
In report Builder we the calculations have been transfered to ONPrint events
either in Pascal or in Rbuilder Events as we have used the Converter tool.
Please suggest.
Thanks.
This discussion has been closed.
Comments
Digital Metaphors does not offer a conversion tool for ReportBuilder so I
cannot comment on the quality of the converted report you are using.
All calculations should be made in the OnCalc event of a TppVariable. This
will ensure that they are only made once per traversal. As a test, you
might try creating one of your reports by hand from scratch and see if it is
the converter that is in fact slowing your reports down.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Have you profiled it? What's the bottle neck?
My best guess is somethings wrong with the way the report was put together.
Ed Dressel
Team DM
27 pages from a master table and traced SQL Profiler. I found that the
Select * from
fires... you mean opens & closes? Send it support and see what they can do.
--
Ed Dressel
Team DM