We have added some custom attributes to the Customer Account. Now we need to generate sales reports that will take the data from these attributes. The reports need to be accessible from the admin section and exportable to csv or excel format (similar to native Magento reports).
Report 1: (Product Detailed Report) Filter by: Date, Physician Name or Referral Code
Product Code / Description / Qty / Sales Amt / SH Amount / Tax Amount / Net Sales* / Phys. Name / Phys. State / Referral Code / Customer Group
*Net Sales = Sales amount less SH less Tax
Report 2: (Customer Summary Report) Filter by: Date, Physician Name, Referral Code or Customer Group
Customer Name / First Order Date / Last Order Date / Total Sales Amt / SH Amount / Tax Amount / Net Sales / Phys. Name / Phys. State / Referral Code / Customer Group
First Order Date = date when first order was entered in Magento
Last order date = date when latest order was entered in Magento
Expert Magento developer needed.