home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Buyer 1999 March
/
Dpcb0399.iso
/
MONEY
/
Capital
/
SETUP.2
/
REPORTS
/
NLDETRIA.REP
< prev
next >
Wrap
Text File
|
1995-06-21
|
16KB
|
463 lines
VERSION 2.00
Begin Report NLDETRIA.REP
Caption = "NLDETRIA.REP"
Width = 13515
Height = 15765
Reportheader = 1125
Header = 1515
Transaction = 10545
SubTotal = 435
Footer = 1560
Pagefooter = 15615
Replicate = 345
Style = 0
Query = "NLNAME NNBALANCE<>0 ORDER BY NNGROUP+NNACCOUNT"
Macro = "0CD:When REPTOT(6)=0 then REPSTR(0)="' '""
Macro = "1OF:@REPVARS.REPSTR(2) = "' '""
Macro = "1OF:@REPVARS.REPSTR(1) = "' '""
Macro = "1CD:When REPTOT(6)=1 then SKIP 3"
Macro = "1LU:Select from NLGRPS where NGCODE=NLNAME.NNGROUP"
Macro = "1OF:@REPVARS.REPSTR(0) = "'"+NLNAME.NNGROUP+"'""
Macro = "1CD:When NLNAME.NNGROUP=REPSTR(0) then SKIP 3"
Macro = "1OF:@REPVARS.REPSTR(1) = "'"+TRIM(NLGRPS.NGDESC)+" Group Total'""
Macro = "1OF:@REPVARS.REPSTR(2) = "'___________________________'""
Macro = "1OF:@REPVARS.REPTOT(6) = 1"
Macro = "1OF:@REPVARS.REPSTR(0) = "'"+NLNAME.NNGROUP+"'""
Macro = "2SQ:Select from NLTRAN where NTCODE=NLNAME.NNACCOUNT"
Macro = "2PP:@REPVARS.REPTOT(0) = REPTOT(0)+NLTRAN.NTVALUE"
Macro = "2CD:When LEN(TRIM(REPSTR(1)))<>0 then REPTOT(1)=0"
Macro = "3OF:@REPVARS.REPTOT(1) = REPTOT(1)+REPTOT(0)"
Macro = "3CD:When REPTOT(0)>0 then REPTOT(3)=REPTOT(3)+REPTOT(0)"
Macro = "3PP:@REPVARS.REPTOT(0) = 0"
Macro = "3LU:Select from NLGRPS where NGCODE=@REPVARS.REPSTR(0)"
Macro = "4LU:Select from NLGRPS where NGCODE=NLNAME.NNGROUP"
Macro = "4OF:@REPVARS.REPSTR(1) = "'"+TRIM(NLGRPS.NGDESC)+" Group Total'""
Macro = "4PP:@REPVARS.REPTOT(1) = 0"
Macro = "4PP:@REPVARS.REPTOT(2) = 0"
Macro = "4PP:@REPVARS.REPTOT(3) = 0"
Macro = "4PP:@REPVARS.REPTOT(6) = 0"
Macro = "4PP:@REPVARS.REPSTR(1) = " ""
Macro = "4PP:@REPVARS.REPSTR(0) = " ""
Macro = "4PP:@REPVARS.REPSTR(2) = " ""
BreakOn = "NLNAME.NNACCOUNT"
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Detailed Trial Balance"
Font = "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 375
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 = 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 = 9180
Top = 720
Width = 1800
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 = 9
Caption = "REPSTR(2)"
Font = "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4590
Top = 450
Width = 2835
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Type"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 2295
Top = 1290
Width = 735
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Entry"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 1305
Top = 1275
Width = 600
End
Begin Control NNACCNAME
Type = "Text"
Style = 0
Fieldname = "NNACCNAME"
Filename = "NLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 1155
Top = 885
Width = 2895
End
Begin Control NNACCOUNT
Type = "Text"
Style = 0
Fieldname = "NNACCOUNT"
Filename = "NLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 45
Top = 885
Width = 1005
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 = 90
Top = 1275
Width = 870
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Input By"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 3240
Top = 1290
Width = 870
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Debit"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 4665
Top = 1305
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Credit"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 6345
Top = 1305
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "REPSTR(1)"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 495
Top = 375
Width = 3810
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(LEN(TRIM(REPSTR(1))),CORD(REPTOT(1),10,2,2)," ")"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4335
Top = 360
Width = 1485
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(LEN(TRIM(REPSTR(1))),CORD(REPTOT(1),10,2,-2)," ")"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 6015
Top = 360
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "REPSTR(2)"
Font = "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4590
Top = 45
Width = 2835
End
Begin Control NTTXNDATE
Type = "Text"
Style = 0
Fieldname = "NTTXNDATE"
Filename = "NLTRAN"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 45
Top = 45
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "MID(" Journal Sales Purchase",NLTRAN.NTTXNTYPE*8,8)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 2295
Top = 45
Width = 870
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "CORD(NLTRAN.NTVALUE,10,2,1)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 4260
Top = 60
Width = 1545
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "CORD(NLTRAN.NTVALUE,10,2,-1)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 5880
Top = 60
Width = 1545
End
Begin Control NTCOMMENT
Type = "Text"
Style = 0
Fieldname = "NTCOMMENT"
Filename = "NLTRAN"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 7635
Top = 45
Width = 2760
End
Begin Control NTINPUTBY
Type = "Text"
Style = 0
Fieldname = "NTINPUTBY"
Filename = "NLTRAN"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 3285
Top = 45
Width = 735
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "mid(NLTRAN.NTENTRYNO+" ",5,5)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 1350
Top = 45
Width = 735
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(NLNAME.NNANNBUDG<>0,STR(NLNAME.NNANNBUDG,10,0)," ")"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 10470
Top = 60
Width = 1545
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "___________________________"
Font = "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 4590
Top = 225
Width = 2835
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "CORD(REPTOT(0),10,2,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 4605
Top = 180
Width = 1215
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "CORD(REPTOT(0),10,2,-2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 6210
Top = 180
Width = 1215
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "___________________________"
Font = "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 4575
Top = 405
Width = 2835
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Totals"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 2625
Top = 1230
Width = 885
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(3),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 4590
Top = 1230
Width = 1215
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(3),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 6210
Top = 1215
Width = 1215
End
Begin Control BOX
Type = "Box"
Style = 8
Location = "Footer Block"
Height = 45
Left = 4605
Top = 1110
Width = 2835
End
Begin Control BOX
Type = "Box"
Style = 8
Location = "Footer Block"
Height = 45
Left = 4605
Top = 1515
Width = 2835
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "REPSTR(1)"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 465
Top = 345
Width = 3900
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "CORD(REPTOT(1),10,2,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 4605
Top = 345
Width = 1215
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "CORD(REPTOT(1),10,2,-2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 6195
Top = 345
Width = 1215
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "___________________________"
Font = "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 4590
Top = 75
Width = 2835
End