Recently I have been building a system that required some interaction with Google Maps in terms of creating multiple custom markers to a map. There are many different approaches to solving this problem but I thought I would share my particular twist on this in this post.
Monthly Archives: April 2011
Optimising the Case Statement
There are a few optimisation strategies for Case. At a simple level consider the Let statement… Let([ f1 = field1; f2 = field2 ]; Case ( f1 = 0 and f2 = 0 ; <result1> ; f1 = 0 and f2 = 1 ; <result2> ; f1 = 1 and f2 = 0 ; <result3>…
Sub-summarys within portals pt I
There are a few ways to achieve a ‘sub summary’ look with in a portal. The simplest is to hide repeating data with conditional formatting. Using the getnthrecord to work out if you are on the first or last record and showing relevant data. If you wish to show a sum then you will need…
