New Report on Referral Code required. Possible?

[rgeorgiou]

Good morning all,

I have a situation where I need a report to be generated at the end of each month that shows me the amount of items purchased for each referral code.

I want the layout to be as follows:

Month: drop down box
Year: drop down box

Club Code Products Sold Total to pay
=======================================
GL234 014 070
GL345 003 015
GL635 023 115
GL698 004 020
END
=======================================

I've been told by my programmer that this is not possible on the referral code and that he will have to use the coupon code. Doing this on the coupon code will not work for us as we use the referral code in other areas throughout the site.

Is is possible to create the report that I need? If so would anyone like to tender?

Best regards
Richard Georgiou
LASTRAP

[kuroi]

I hate to contradict another professional, but of course this is possible.

It would be rather more complex than doing it by coupon code, since the coupon code is held in the orders table with the rest of the data that would be needed for this report, whereas the referral code is held in the customers table and so (in technical terms) the database query that extracts the information for the report would need to "join" the two tables - but that's basic stuff for anybody with a bit of database experience.

[thomasw98]

I hate to contradict another professional, but of course this is possible.

It would be rather more complex than doing it by coupon code, since the coupon code is held in the orders table with the rest of the data that would be needed for this report, whereas the referral code is held in the customers table and so (in technical terms) the database query that extracts the information for the report would need to "join" the two tables - but that's basic stuff for anybody with a bit of database experience.

It is scary that I am actually beginning to understand what you mean when you give these technical answers...maybe I should have been a computer programmer?!?