home *** CD-ROM | disk | FTP | other *** search
- VERSION 2.00
- Begin Report STPRICE.REP
- Caption = "STPRICE.REP"
- Width = 11460
- Height = 16185
- Reportheader = 1200
- Header = 825
- Transaction = 9990
- SubTotal = 285
- Footer = 0
- Pagefooter = 15960
- Replicate = 675
- 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 = 270
- 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 = 1725
- Top = 270
- 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 = 3975
- Top = 270
- 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 = 3975
- Top = 540
- 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 = 4920
- Top = 270
- 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 = 5595
- Top = 270
- 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 = 390
- Width = 1230
- 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 = 1290
- Top = 390
- 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 = 3840
- Top = 390
- 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 = 4770
- Top = 390
- 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 = 5670
- Top = 405
- 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 = 6345
- Top = 405
- 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 = 7560
- Top = 405
- 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 = 8235
- Top = 405
- 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 = 9450
- Top = 405
- 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 = 10125
- Top = 405
- 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 = 5400
- Top = 405
- 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 = 6075
- Top = 405
- 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 = 7290
- Top = 405
- 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 = 7965
- Top = 405
- 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 = 9180
- Top = 405
- 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 = 9855
- Top = 405
- Width = 270
- End
-