need help for commission report by item

[alfred723]

I created a commission report telling me how much commission a salesman gets for total sale. there are different commission rates for different items. I'm having trouble creating a formula telling Crystal reports to sum the commission totals by commission rates. Can someone please help??


DATE SALESMAN# PRODUCT WEIGHT AVG. EXTENSION
CODE PRICE


8/15/03 10 002 10 3.99 39.90
8/17/03 10 007 3 3.19 9.57
8/20/03 12 012 240 1.90 456.60
8/15/03 17 178 5 2.17 10.85
COMMISSION PRODUCT TOTAL PRODUCT
RATE COMMISSION COMMISSION NAME

.0340 .34 .34 TBONE
.0340 .10 .10 CHUCK STEAK
.0240 5.76 5.76 BONLESS STEW
.0165 .08 .08 CHEESE


(COMMISSION TOTALS ARE SEPERATED BY SALESMAN AND COMMISSION RATE)

TOTALS FOR SALEMAN # (SALESMAN # WOULD GO HERE)

.0340 .0240 .0165
(COMMISSION TOTALS WOULD GO HERE BY COMMISSION RATES )

NEXT PAGES WOULD HAVE OTHER SALESMAN TOTALS BY COMMISSION RATES. PLEASE HELP

 

[FVTrainer]

That looks like a classic cross-tab. Are you grouping by Salesman? If so, create a cross tab that uses the commission rate as the column and sums the total commission amount. The salesperson could be the row. Place the cross tab in the salesman group footer.

Formatting cross-tabs can be a pain; you'll probably need to suppress the totals and perhaps the lines. If you need the order of your commission rates reversed (to show highest to lowest), one approach would be to create a formula as follows:

CommissionRate:

-(Commission Totals}

Use this formula as the column for the cross tab, and format the number to reverse the sign for display (in preview mode, right-click on the commission rate, choose Format Field | Number | Customize, and select the "Reverse sign for display" option)