Aug
26
2011

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.

Comments (4) -

Josh T

Great article, Derek! Keep 'em coming!

Anita Parsley

LOVE that you guys are doing this.  I may not always understand that the heck you are talking about but I'll follow it anywaySmile

angle finder

Just letting you know that I really like your web site, and I come here every day for the valuable information you provide. Keep up the great work!

polyurethane finish

Greetings!! This is a real cool website.

quotes of life

brillant piece of information, I had come to know about your web-page  from my friend hardkik, chennai,i have read atleast 9 posts of yours by now, and let me tell you, your webpage gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanx a million once again, Regards, <a href="http://lifequotes99.com">quote of life</a>

Add comment

biuquote
  • Comment
  • Preview
Loading

Calendar

<<  May 2012  >>
MoTuWeThFrSaSu
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

View posts in large calendar