I made this and I figured perhaps some of you can make use of it.
It makes use of the Comm Rate 1, Break, and Comm Rate 2 fields for sales People.
PLEASE NOTE!!! You MUST increase fieldname length to 255 in reportfields table for this to work due to the very long SQL string!
The report calculates commission based upon how long a customer has been on board. If <= BREAK (months) it uses RATE 1 and if > BREAK (months) it uses RATE 2.
Perhaps some of you can use this as a starting point for other sorts of commission reports...
If you do come up with something based upon this please share it back with the community!