home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Buyer 1999 March
/
Dpcb0399.iso
/
MONEY
/
Capital
/
SETUP.2
/
REPORTS
/
STPRICE.REP
< prev
next >
Wrap
Text File
|
1996-03-07
|
10KB
|
306 lines
VERSION 2.00
Begin Report STPRICE.REP
Caption = "STPRICE.REP"
Width = 11475
Height = 16185
Reportheader = 1200
Header = 1065
Transaction = 9750
SubTotal = 285
Footer = 0
Pagefooter = 15960
Replicate = 705
Style = 8
Query = "STNAME CNPRODTYPE="2" ORDER BY CNPRODID"
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 = "Price List"
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 = 1800
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 = 540
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 = 2265
Top = 540
Width = 1785
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Selling"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 4515
Top = 540
Width = 915
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Price"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 4515
Top = 810
Width = 915
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Per"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 5460
Top = 540
Width = 510
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "---------------------------------- Discounted Prices ----------------------------------"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 6000
Top = 540
Width = 5640
End
Begin Control CNPRODID
Type = "Text"
Style = 0
Fieldname = "CNPRODID"
Filename = "STNAME"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 30
Top = 420
Width = 1635
End
Begin Control CNDESC
Type = "Text"
Style = 0
Fieldname = "CNDESC"
Filename = "STNAME"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 1830
Top = 420
Width = 2490
End
Begin Control CNSELPRICE
Type = "Text"
Style = 0
Fieldname = "CNSELPRICE"
Filename = "STNAME"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 4380
Top = 420
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 = 5445
Top = 420
Width = 600
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNDISCODE1<>"",STR(STNAME.CNDISC1,5,2),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 6210
Top = 435
Width = 405
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNDISCODE1<>"",STR((1-(STNAME.CNDISC1/100))*STNAME.CNSELPRICE,10,2),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 6885
Top = 435
Width = 870
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNDISCODE2<>"",STR(STNAME.CNDISC2,5,2),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 8100
Top = 435
Width = 405
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNDISCODE2<>"",STR((1-(STNAME.CNDISC2/100))*STNAME.CNSELPRICE,10,2),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 8775
Top = 435
Width = 870
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNDISCODE3<>"",STR(STNAME.CNDISC3,5,2),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 9990
Top = 435
Width = 405
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNDISCODE3<>"",STR((1-(STNAME.CNDISC3/100))*STNAME.CNSELPRICE,10,2),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 10665
Top = 435
Width = 870
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNDISCODE1<>"",STNAME.CNDISCODE1,"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 5940
Top = 435
Width = 270
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNDISCODE1<>"","%","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 6615
Top = 435
Width = 270
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNDISCODE2<>"",STNAME.CNDISCODE2,"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 7830
Top = 435
Width = 270
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNDISCODE2<>"","%","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 8505
Top = 435
Width = 270
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNDISCODE3<>"",STNAME.CNDISCODE3,"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 9720
Top = 435
Width = 270
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNDISCODE3<>"","%","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 10395
Top = 435
Width = 270
End