home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Buyer 1999 March
/
Dpcb0399.iso
/
MONEY
/
Capital
/
SETUP.2
/
REPORTS
/
SLAREA.REP
< prev
next >
Wrap
Text File
|
1996-03-06
|
11KB
|
342 lines
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 = 8145
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 = 4920
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 = 7140
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 = 9090
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 = 8115
Top = 180
Width = 900
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 = 4725
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 = 870
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 = 7050
Top = 180
Width = 1005
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 = 9060
Top = 180
Width = 1980
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 = 2790
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 = 4725
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 = 2790
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 = 4725
Top = 450
Width = 1080
End