Sub summaries in portals
March 15th, 2010
Well what do you do when a client says they need a running total in a portal? The first thing that came to mind was some sort of self join summing related records and nasty filters to make it all sequential. Yuck.
Anyway just to see what happens I thought I would stick a running total in the portal line and what do you know? It works. That makes life a lot simpler.