A bit complicated so here goes...the records i am trying to pull and summarize represent trades. Each trade is represented by one salesman (most of the time) who earns the commission on that trade. However, the trade platform where we enter the trade information in allows for a commission override. That is, the trade commission amount can be shared by two salesman if needed, instead of jus the primary salesman on the account.
I am trying to create a commissions report using Crystal Reports XI. My initial setup was to use a cross-tab to quickly sum up the commissions earned for each salesman. This works well, except since its configured to group/summarize the rows by primary salesman, it does not factor in to the any trades that each broker was a secondary salesman. I am hitting a wall here on how to group the cross-tab by salesman and have it total both primary and/or secondary trade commissions for each salesman. How to have one record be displayed on more than one line so i can show that Jack's commission total represents his share of trade 1 and Jill's total also reflects her share of trade 1....stored proceedure needed? or can i accomplish this using formulas?
Let me know if you need more clearity in the matter.
see attached for sample of data