home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Buyer 1999 March
/
Dpcb0399.iso
/
MONEY
/
Capital
/
SETUP.2
/
REPORTS
/
STPOUT.REP
< prev
next >
Wrap
Text File
|
1996-03-07
|
12KB
|
364 lines
VERSION 2.00
Begin Report STPOUT.REP
Caption = "STPOUT.REP"
Width = 11460
Height = 16185
Reportheader = 1200
Header = 1185
Transaction = 9585
SubTotal = 1620
Footer = 570
Pagefooter = 15960
Replicate = 435
Style = 8
Query = "STTRND CDTYPE="1"&CDPRODTYPE<>"0" ORDER BY CDDOCNO"
Macro = "1LU:Select from STTRNH where CHTRANNO=STTRND.CDTRANNO"
Macro = "2CD:When STTRND.CDQUANTITY<>STTRND.CDQTYBAL then REPTOT(0)=REPTOT(0)+((STTRND.CDQTYBAL/STTRND.CDQUANTITY)*STTRND.CDGOODSVAL)"
Macro = "2CD:When STTRND.CDQUANTITY=STTRND.CDQTYBAL then REPTOT(0)=REPTOT(0)+STTRND.CDGOODSVAL"
Macro = "2LU:Select from STNAME where CNPRODID=STTRND.CDPRODID"
Macro = "3OF:@REPVARS.REPTOT(1) = REPTOT(1)+REPTOT(0)"
Macro = "3PP:@REPVARS.REPTOT(0) = 0"
Macro = "4PP:@REPVARS.REPTOT(0) = 0"
Macro = "4PP:@REPVARS.REPTOT(1) = 0"
BreakOn = "STTRND.CDTRANNO"
Special = "TXNRANGE(CDTRANNO,CDCREATION)"
End
Begin Control LABEL
Type = "Label"
Style = 12
Caption = "TRIM(SYSTEM.COMPNAME)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 270
Left = -15
Top = 405
Width = 11070
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Outstanding Purchase Orders"
Font = "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 420
Left = 135
Top = 675
Width = 11025
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "DTOC(DATE())"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 285
Left = 135
Top = 705
Width = 3285
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = ""Page: "+PAGENUM()"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 285
Left = 9585
Top = 720
Width = 1395
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Product ID"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 30
Top = 675
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Description"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 2130
Top = 675
Width = 1110
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Quantity"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 5460
Top = 675
Width = 780
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Unit"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 4650
Top = 675
Width = 510
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Balance"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 6630
Top = 675
Width = 780
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Value"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 7980
Top = 675
Width = 1050
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Outstanding"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 7980
Top = 945
Width = 1050
End
Begin Control CHDOCNO
Type = "Text"
Style = 0
Fieldname = "CHDOCNO"
Filename = "STTRNH"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 1080
Top = 270
Width = 1275
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Order No. :"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 30
Top = 270
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Supplier ID :"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 2460
Top = 270
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Date :"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 5025
Top = 270
Width = 675
End
Begin Control CHTXNDATE
Type = "Text"
Style = 0
Fieldname = "CHTXNDATE"
Filename = "STTRNH"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 5790
Top = 270
Width = 870
End
Begin Control CHACCID
Type = "Text"
Style = 0
Fieldname = "CHACCID"
Filename = "STTRNH"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 3570
Top = 270
Width = 1140
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Due Date :"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 6780
Top = 270
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 12
Caption = "IF(STTRNH.CHDUEDEL<>NULLDATE & STTRNH.CHDUEDEL<DATE(),"<< Order Overdue >>","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 8865
Top = 270
Width = 1755
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STTRNH.CHDUEDEL<>NULLDATE,DTOC(STTRNH.CHDUEDEL),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 7830
Top = 285
Width = 810
End
Begin Control CDPRODID
Type = "Text"
Style = 0
Fieldname = "CDPRODID"
Filename = "STTRND"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 30
Top = 165
Width = 1635
End
Begin Control CDDESC
Type = "Text"
Style = 0
Fieldname = "CDDESC"
Filename = "STTRND"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 1815
Top = 165
Width = 2760
End
Begin Control CDQUANTITY
Type = "Text"
Style = 0
Fieldname = "CDQUANTITY"
Filename = "STTRND"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 5370
Top = 165
Width = 870
End
Begin Control CNUNITDESC
Type = "Text"
Style = 0
Fieldname = "CNUNITDESC"
Filename = "STNAME"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 4620
Top = 165
Width = 510
End
Begin Control CDQTYBAL
Type = "Text"
Style = 0
Fieldname = "CDQTYBAL"
Filename = "STTRND"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 6645
Top = 165
Width = 870
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STTRND.CDQUANTITY<>STTRND.CDQTYBAL,STR((STTRND.CDQTYBAL/STTRND.CDQUANTITY)*STTRND.CDGOODSVAL,10,2),STR(STTRND.CDGOODSVAL,10,2))"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 7920
Top = 165
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = ""Total Value Outstanding for Order = ""
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 5445
Top = 570
Width = 2430
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(0),10,2)"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 7920
Top = 570
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(1),10,2)"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 7920
Top = 300
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = ""Total Value Outstanding = ""
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 5445
Top = 300
Width = 2430
End