Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Report Speed Goes slow on calculation

edited November 2006 in General
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.

Comments

  • edited November 2006
    Hi Dipak,

    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited December 2006
    > I got good satisfactory answer for my first question. I noticed that

    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
  • edited December 2006
    I tried putting a simple TTable component with Single table to print almost
    27 pages from a master table and traced SQL Profiler. I found that the
    Select * from Query fires 4 times !


  • edited December 2006
    > Select * from Query fires 4 times !

    fires... you mean opens & closes? Send it support and see what they can do.

    --
    Ed Dressel
    Team DM
This discussion has been closed.