Completely lost trying to duplicate a report by codemonkey76 » Fri Dec 14, 2007 1:36 pm
I have a report that i used to use with the DOS version of capital and have no idea how to reproduce it using the windows version, can someone please help.
Here it is:
#LAYOUT
TITLE = "Customer Sales Summary"
DATABASE = INVOICE
LINK = CUSTOMER->ACCOUNT
TOP = 1
BOTTOM = 1
LEFT = 0
HEADER = "[ANSWER3] Sales for [answer1] - [answer2], Page No. [PAGENO]"
SORT = (3)
SOFTSEEK = answer1
TOTAL = @SUM([FTOTAL]-[FREIGHT]), " GROSS SALES: {@Z $99,999,999.99}"
TOTAL = @SUM([TTOTAL]), " TOTAL TAX: {@Z $99,999,999.99}"
TOTAL = @SUM([FREIGHT]), " FREIGHT: {@Z $99,999,999.99}"
TOTAL = @SUM([INVTOT]), " SUB-TOTAL: {@Z $99,999,999.99}"
TOTAL = @SUM([TCOST]), " TOTAL COST: {@Z $99,999,999.99}"
TOTAL = @SUM([FTOTAL]-[FREIGHT] - [TCOST]), " TOTAL G.P.M.: {@Z $99,999,999.99}"
TOTAL = @MARGIN([FTOTAL]-[FREIGHT], [TCOST]), " RELATIVE G.P.M.: {@Z 99,999,999.99%}"
TOTAL = @MARKUP([FTOTAL]-[FREIGHT], [TCOST]), " MARKUP ON COST: {@Z 99,999,999.99%}"
#INPUT
@INPUT("Enter start date of report", [DATE], answer1)
@INPUT("Enter end date of report", [DATE], answer2)
@INPUT("Enter Customer Code", [ACCCODE], answer3)
#RULES
EXIT [DATE] > answer2
AND [ITYPE] # "6"
AND [CUSTYPE] # "I"
AND [ACCCODE] = answer3
#BODY