Agent: Fred Policy # Amount Received Policy Year Commission 12345 120 1 1.00 2 0.50 54321 200 1 2.00 09876 240 1 3.00 ______ _______ 560 6.50The data that is used to drive the report is similar to this:
Agent Policy AmtReceived PolicyYear Commission Receipt Fred 12345 120 1 1.00 001 Fred 12345 120 2 0.50 001 Fred 54321 200 1 2.00 002 Fred 12345 240 1 3.00 003A receipt's amount can be split into multiple records.