Season
Starting Member
37 Posts |
Posted - July 09 2008 : 23:02:33
|
Hi, I am trying to generate a sales report, version 4.5 I am trying to get the total with out the Sales Tax and Shipping. Is there a way to use ORDERAMOUNT - Tax - Shipping in the Fields below so it would show this amount less the tax and shipping.
I have include what is in the Shopa_reports.asp ver 4.5
Fields(0)="ORDERID" Fields(1)="ORDERAMOUNT" Fields(2)="Odate" Fields(3)="ofirstname" Fields(4)="olastname" Fields(5)="oaddress" Fields(6)="oCity" Fields(7)="ostate" Fields(8)="ocountry" Fields(9)="Otax" Fields(10)="oshipcost" Fields(11)=("orderamount-otax-oshipcost") <<<<---NOTE this doesnot work, can someone tell me what it should be fieldcount=11
CapFields(0)=LangProductOrderNumber CapFields(1)=LangProductTotal CapFields(2)=LangStatusDate CapFields(3)=LangCustFirstName CapFields(4)=LangCustLastName CapFields(5)=LangCustAddress CapFields(6)=LangCustCity capFields(7)=LangCustState capFields(8)=LangCustCountry capFields(9)=LangProductTax capFields(10)=LangFormatShippingInformation capFields(11)=LangProductTotal
Thanks
Cliff |
Edited by - Season on July 10 2008 18:29:56 |
|