Report Problem

[nickcook_01]

I need to make a report that shows the cost of goods, the sale price of the goods, and the gross profit for the goods, but only for a certain portion of the inventory and only for certain customers, does anybody have an idea on what I should use?? I need the report to figure out an employees comm.

I will try to show an example below


Cost Sale Price Gross Profit
Customer A
Widget 2.00 4.00 2.00
Woget 3.00 6.00 3.00

Customer B
Widget 2.00 4.00 2.00


etc, etc,

Also it needs to show the qty. sold to the customer

Thanks,
Nick