Hi All,
I am having problem with my current coding.
I have a file with Department Id, Agent Id Month and Sales info. There will be 2 - 4 occurence for a particular agent. I have to create a report for every agent with Agent Id and Department Id dipslayed on the top and Month and Sales Info as detailed lines. I am able to do one agent per page I am to put 3 agents per page but I couldnt. Any Help will be appreciated...
The Report should look like
ABC Insurance Co Page 1
XXx UUUU
Agent id : 12345
Department : P&C
Month Sales
-------------------------
01 $3,000.00
02 $3,000.00
01 $3,000.00
Agent id : 12345
Department : P&C
Month Sales
-------------------------
01 $3,000.00
02 $3,000.00
01 $3,000.00
Agent id : 12345
Department : P&C
Month Sales
-------------------------
01 $3,000.00
02 $3,000.00
01 $3,000.00
ABC Insurance Co Page 2
XXx UUUU
Agent id : 12345
Department : P&C
Month Sales
-------------------------
01 $3,000.00
02 $3,000.00
01 $3,000.00
Agent id : 12345
Department : P&C
Month Sales
-------------------------
01 $3,000.00
02 $3,000.00
01 $3,000.00
Agent id : 12345
Department : P&C
Month Sales
-------------------------
01 $3,000.00
02 $3,000.00
01 $3,000.00