home *** CD-ROM | disk | FTP | other *** search
- VERSION 2.00
- Begin Report SLANAL.REP
- Caption = "SLANAL.REP"
- Width = 11175
- Height = 15795
- Reportheader = 975
- Header = 915
- Transaction = 10785
- SubTotal = 1200
- Footer = 840
- Pagefooter = 15615
- Replicate = 390
- Style = 8
- Query = "SLANDT ALL ORDER BY SAANALHEAD"
- Macro = "2LU:Select from SLANHD where SHCODE=SLANDT.SAANALHEAD"
- Macro = "2OF:@REPVARS.REPTOT(0) = REPTOT(0)+SLANDT.SAVALUE"
- Macro = "2OF:RUNTIME.ALPHAFIELD = SLANDT.SAANALHEAD"
- 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.SAANALHEAD"
- 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 = "Sales 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 = 3420
- 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 = 135
- 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 = 4440
- Top = 510
- Width = 1005
- 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 = 3825
- 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 = 5580
- 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 = 6930
- 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 = 810
- 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 = 3255
- 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 = 9225
- 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 = 135
- Top = 120
- 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 = 8145
- Top = 120
- Width = 1005
- 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 = 4440
- Top = 120
- 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 = 3780
- Top = 120
- Width = 675
- 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 = 5580
- Top = 120
- 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 = 6930
- Top = 120
- 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 = 810
- Top = 120
- 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 = 3360
- Top = 120
- Width = 330
- 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 = 9225
- Top = 120
- Width = 1545
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = ""Total for Group "+LEFT(RUNTIME.ALPHAFIELD,4)"
- Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Subtotal Block"
- Height = 270
- Left = 1695
- Top = 420
- Width = 2565
- 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 = 4440
- Top = 420
- 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 = 1695
- Top = 570
- Width = 2565
- 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 = 4440
- Top = 570
- Width = 1080
- End
-