User Defined (global) functions called from datawindows/reports

I recently created a custom Advisor report that used a global function in order to avoid duplicating code and ease of completion.  It works pretty well but you have to be cautious about where you use these things and the amount of code you put into them.  If you have a large amount of code in a global function it will slow down your report since the function will be called at least once for every single row retrieved.  If you use the function in a computed field in a group you'll be calling it many more times because each instance of the function in a computed field will be called for every row retrieved from the database.  You can quickly make a report that runs unacceptably long.

Continue Reading »

An article by Derek 3 Comments