home *** CD-ROM | disk | FTP | other *** search
- VERSION 2.00
- Begin Report SLAREA.REP
- Caption = "SLAREA.REP"
- Width = 11175
- Height = 15795
- Reportheader = 975
- Header = 855
- Transaction = 10305
- SubTotal = 1860
- Footer = 720
- Pagefooter = 15615
- Replicate = 450
- Style = 8
- Query = "SLANDT SAVATCODE<>"0" ORDER BY SASUBANAL+SAANALHEAD"
- Macro = "2LU:Select from SLANHD where SHCODE=SLANDT.SAANALHEAD"
- Macro = "2OF:@REPVARS.REPTOT(0) = REPTOT(0)+SLANDT.SAVALUE"
- Macro = "2OF:RUNTIME.ALPHAFIELD = SLANDT.SASUBANAL"
- 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 = "SLANDT.SASUBANAL"
- Special = "TXNRANGE(SA_IC_NO,SACREATION)"
- 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 = "Area Code Analysis List"
- Font = "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Reportheader Block"
- Height = 420
- Left = 0
- 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 = 3555
- 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 = "Group"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 645
- Top = 510
- Width = 600
- End
- Begin Control LABEL
- Type = "Label"
- Style = 1
- Caption = "Reference"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 8415
- Top = 510
- Width = 1005
- End
- Begin Control LABEL
- Type = "Label"
- Style = 2
- Caption = "Value"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 5055
- Top = 510
- Width = 735
- End
- Begin Control LABEL
- Type = "Label"
- Style = 4
- Caption = "Type"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 4275
- Top = 510
- Width = 465
- End
- Begin Control LABEL
- Type = "Label"
- Style = 1
- Caption = "Customer ID"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 6045
- Top = 510
- Width = 1140
- End
- Begin Control LABEL
- Type = "Label"
- Style = 4
- Caption = "Date"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 7275
- Top = 510
- Width = 735
- End
- Begin Control LABEL
- Type = "Label"
- Style = 1
- Caption = "Description"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 1350
- Top = 510
- Width = 1005
- End
- Begin Control LABEL
- Type = "Label"
- Style = 4
- Caption = "VAT"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 3675
- Top = 510
- Width = 465
- End
- Begin Control LABEL
- Type = "Label"
- Style = 1
- Caption = "Area"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 90
- Top = 510
- Width = 465
- End
- Begin Control LABEL
- Type = "Label"
- Style = 1
- Caption = "Product ID"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 9630
- Top = 510
- Width = 1005
- End
- Begin Control SAANALHEAD
- Type = "Text"
- Style = 0
- Fieldname = "SAANALHEAD"
- Filename = "SLANDT"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 615
- Top = 180
- Width = 600
- End
- Begin Control SAREF
- Type = "Text"
- Style = 0
- Fieldname = "SAREF"
- Filename = "SLANDT"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 8385
- Top = 180
- Width = 1170
- End
- Begin Control SAVALUE
- Type = "Text"
- Style = 0
- Fieldname = "SAVALUE"
- Filename = "SLANDT"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 4860
- Top = 180
- Width = 1080
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(SLANDT.SATYPE="I","Invce","Cnote")"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 4230
- Top = 180
- Width = 585
- End
- Begin Control SAACCOUNT
- Type = "Text"
- Style = 0
- Fieldname = "SAACCOUNT"
- Filename = "SLANDT"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 6090
- Top = 180
- Width = 1005
- End
- Begin Control SADATE
- Type = "Text"
- Style = 0
- Fieldname = "SADATE"
- Filename = "SLANDT"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 7185
- Top = 180
- Width = 1140
- End
- Begin Control SHDESCRIPT
- Type = "Text"
- Style = 0
- Fieldname = "SHDESCRIPT"
- Filename = "SLANHD"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 1290
- Top = 180
- Width = 2490
- End
- Begin Control SAVATCODE
- Type = "Text"
- Style = 0
- Fieldname = "SAVATCODE"
- Filename = "SLANDT"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 3825
- Top = 180
- Width = 330
- End
- Begin Control SASUBANAL
- Type = "Text"
- Style = 0
- Fieldname = "SASUBANAL"
- Filename = "SLANDT"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 60
- Top = 180
- Width = 465
- End
- Begin Control SAPRODID
- Type = "Text"
- Style = 0
- Fieldname = "SAPRODID"
- Filename = "SLANDT"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 9600
- Top = 180
- Width = 1440
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = ""Total for Area "+LEFT(RUNTIME.ALPHAFIELD,2)"
- Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Subtotal Block"
- Height = 270
- Left = 2925
- Top = 1230
- Width = 1890
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "STR(REPTOT(0),10,2)"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Subtotal Block"
- Height = 270
- Left = 4860
- Top = 1230
- Width = 1080
- End
- Begin Control LABEL
- Type = "Label"
- Style = 1
- Caption = "Total"
- Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Footer Block"
- Height = 270
- Left = 2925
- Top = 450
- Width = 1890
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "STR(REPTOT(1),10,2)"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Footer Block"
- Height = 270
- Left = 4860
- Top = 450
- Width = 1080
- End
-