home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Buyer 1999 March
/
Dpcb0399.iso
/
MONEY
/
Capital
/
SETUP.2
/
REPORTS
/
SLODSTAT.REP
< prev
next >
Wrap
Text File
|
1995-06-21
|
15KB
|
437 lines
VERSION 2.00
Begin Report SLODSTAT.REP
Caption = "SLODSTAT.REP"
Width = 11175
Height = 15810
Reportheader = 0
Header = 4590
Transaction = 9330
SubTotal = 1590
Footer = 0
Pagefooter = 15690
Replicate = 525
Style = 12
Query = "SLTRAN ORDER BY SLTRAN.STACCOUNT+DTOS(SLTRAN.STTXNDATE)"
Macro = "1LU:Select from SLNAME where SLNAME.SNACCOUNT=SLTRAN.STACCOUNT"
Macro = "1OF:@REPVARS.REPTOT(7) = REPTOT(7)+1"
Macro = "2OF:@REPVARS.REPTOT(0) = @REPVARS.REPTOT(0)+SLTRAN.STOUTSTAND"
Macro = "2OF:@REPVARS.REPTOT(1) = PERIOD(DATE(),SLTRAN.STTXNDATE)"
Macro = "2CD:When SLTRAN.STTYPE="R" & SLTRAN.STALLOC=" " then REPTOT(1)=-1"
Macro = "2CD:When REPTOT(1)=-1 then REPTOT(6)=REPTOT(6)+SLTRAN.STOUTSTAND"
Macro = "2CD:When REPTOT(1)=0 then REPTOT(2)=REPTOT(2)+SLTRAN.STOUTSTAND"
Macro = "2CD:When REPTOT(1)=1 then REPTOT(3)=REPTOT(3)+SLTRAN.STOUTSTAND"
Macro = "2CD:When REPTOT(1)=2 then REPTOT(4)=REPTOT(4)+SLTRAN.STOUTSTAND"
Macro = "2CD:When REPTOT(1)=3 then REPTOT(5)=REPTOT(5)+SLTRAN.STOUTSTAND"
Macro = "3PP:@REPVARS.REPTOT(0) = 0"
Macro = "3PP:@REPVARS.REPTOT(1) = 0"
Macro = "3PP:@REPVARS.REPTOT(2) = 0"
Macro = "3PP:@REPVARS.REPTOT(3) = 0"
Macro = "3PP:@REPVARS.REPTOT(4) = 0"
Macro = "3PP:@REPVARS.REPTOT(5) = 0"
Macro = "3PP:@REPVARS.REPTOT(6) = 0"
Macro = "3PP:@REPVARS.REPTOT(7) = 0"
BreakOn = "SLTRAN.STACCOUNT"
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = ""Page No. "+STR(REPTOT(7),3,0)"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 10020
Top = 2280
Width = 990
End
Begin Control SNNAME
Type = "Text"
Style = 0
Fieldname = "SNNAME"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 2280
Width = 3645
End
Begin Control SNADD1
Type = "Text"
Style = 0
Fieldname = "SNADD1"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 2535
Width = 3645
End
Begin Control SNADD2
Type = "Text"
Style = 0
Fieldname = "SNADD2"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 2790
Width = 3645
End
Begin Control SNADD3
Type = "Text"
Style = 0
Fieldname = "SNADD3"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 3030
Width = 3645
End
Begin Control SNADD4
Type = "Text"
Style = 0
Fieldname = "SNADD4"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 3285
Width = 3645
End
Begin Control SNPOSTCODE
Type = "Text"
Style = 0
Fieldname = "SNPOSTCODE"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 3540
Width = 3645
End
Begin Control SNACCOUNT
Type = "Text"
Style = 0
Fieldname = "SNACCOUNT"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 7020
Top = 2280
Width = 1350
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = ""Customer ID""
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 5670
Top = 2280
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "DTOC(DATE())"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 8505
Top = 2280
Width = 1080
End
Begin Control COMPNAME
Type = "Text"
Style = 0
Fieldname = "COMPNAME"
Filename = "SYSTEM"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 270
Width = 4995
End
Begin Control COMPADD1
Type = "Text"
Style = 0
Fieldname = "COMPADD1"
Filename = "SYSTEM"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 540
Width = 3375
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Telephone No."
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4185
Top = 810
Width = 1080
End
Begin Control COMPADD2
Type = "Text"
Style = 0
Fieldname = "COMPADD2"
Filename = "SYSTEM"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 810
Width = 3375
End
Begin Control COMPADD3
Type = "Text"
Style = 0
Fieldname = "COMPADD3"
Filename = "SYSTEM"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 1080
Width = 3375
End
Begin Control COMPADD4
Type = "Text"
Style = 0
Fieldname = "COMPADD4"
Filename = "SYSTEM"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 1350
Width = 3375
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Facsimile No."
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4185
Top = 1080
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(TRIM(REPSTR(9))<>"P" & TRIM(SYSTEM.VATREG)<>"",SYSTEM.COUNTRY,"")"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 5265
Top = 1350
Width = 270
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(TRIM(REPSTR(9))<>"P" & TRIM(SYSTEM.VATREG)<>"","VAT Reg. No.","")"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4185
Top = 1350
Width = 1140
End
Begin Control COMPTEL
Type = "Text"
Style = 0
Fieldname = "COMPTEL"
Filename = "SYSTEM"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 5265
Top = 810
Width = 2160
End
Begin Control COMPFAX
Type = "Text"
Style = 0
Fieldname = "COMPFAX"
Filename = "SYSTEM"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 5265
Top = 1080
Width = 2160
End
Begin Control VATREG
Type = "Text"
Style = 0
Fieldname = "VATREG"
Filename = "SYSTEM"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 5535
Top = 1350
Width = 2160
End
Begin Control STTXNDATE
Type = "Text"
Style = 0
Fieldname = "STTXNDATE"
Filename = "SLTRAN"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 540
Top = 255
Width = 1140
End
Begin Control STREF
Type = "Text"
Style = 0
Fieldname = "STREF"
Filename = "SLTRAN"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 3465
Top = 255
Width = 1275
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "MID(" Invoice Cr. NoteReceipt AdjustmtDiscountRefund ", INSTR("ICRADF",SLTRAN.STTYPE)*8+1,8)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 2025
Top = 255
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "CORD(SLTRAN.STVALUE,10,2,1)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 5955
Top = 255
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "CORD(SLTRAN.STVALUE,10,2,-1)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 7710
Top = 255
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(SLTRAN.STVALUE>0 & SLTRAN.STVALUE<>SLTRAN.STOUTSTAND,CORD(SLTRAN.STOUTSTAND,10,2,1),"")"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 9465
Top = 255
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "MID(" Paid AllocDisp ", INSTR("PAD",SLTRAN.STALLOC)*5+1,5)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 5265
Top = 255
Width = 675
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(@REPVARS.REPTOT(0),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 285
Left = 9465
Top = 525
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(@REPVARS.REPTOT(5),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 285
Left = 60
Top = 525
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(@REPVARS.REPTOT(2),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 285
Left = 4515
Top = 525
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(@REPVARS.REPTOT(3),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 285
Left = 3060
Top = 525
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(@REPVARS.REPTOT(4),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 285
Left = 1500
Top = 525
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(@REPVARS.REPTOT(6),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 285
Left = 5955
Top = 525
Width = 1410
End