ReportBuilder 14.06 calls functions too often

rbuser

Hello,

we are using ReportBuilder 14.06 in our application and have registered
several custom functions in our enviroment.

The functions work as expected; we use variable objects to display the
results. However we noticed that ReportBuilder, calls the functions very
often while rendering the report

Even when the variable object is placed in the title band (and therefore
only displayed one time in the rendered document), the function is
called six times or more.

As some functions do database queries, this behavior causes additional
database load and generally lowers the performance of the rendering process.

Is there a reason, why ReportBuilder calls the function so often and is
there a possibility to avoid this?

Best regards,
David Bakker / AdvanTex Software GmbH & Co.KG

nicocizik

Hi David,

Which events are you using?

If you are using variables to make calculations, you need to be sure to
use the OnCalc event. This is the only event that is guaranteed to fire
only once per traversal. If you are using other events such as
Band.BeforePrint, you need to manually check that the event has already
fired so that your code is not executed more than once.

http://www.digital-metaphors.com/rbWiki/Delphi_Code/Calculations/Overview
Best Regards,

Best Regards,

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