getting commissons by product id #

[alfred723]

the report I need to produce is something like this

date salesman# product# weight price
8/15/03 10 001-3 500 $2.00

extension commissionrate productcommision totalcommission
1,000.00 .034 $17.00 $17.00
(rate is per product)

product name
t-bones

Our company has about 100 product names and about five salesmen. the way our salesmen get commission is by product.Each product has a differnt commisson rate.
i tried to use the if function but i don't think i'm doing it right. EXAMPLE: if {lineitem.itemid}= 001 then {jrnlhdr.amount}* .034, "". I've got a report made that shows everthing but, i can't make it sort by salesman to keep all the sales by eachsalesman together nor can i get the commission rates by item. HELP PLEASE

THANKS

 

[Madawc]

For Crystal 8.5, I'd make salesman# a Group. Then do running totals to calculate the commission etc, with values that are found for each detail line and reset for each group. Also you can do formula fields on the detail line to calculate the sum and then total then with a running total.

The only possible drawback is that you get nothing if the salesman has sold nothing. With five salesmen that probably doesn't matter, but you could do a separate running total for each salesman code and put all of them in the report footer.

Madawc Williams
East Anglia, Great Britain