Managed Reporting - Domains - Test - Standard Reports - Test -SAL05
FLATTST
APP HOLD raymond APP FILEDEF raymond DISK WHTWER/whatwere.txt TABLE FILE WHTWER PRINT CONO01 LOCA01 HEADING "" FOOTING "" ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT,
*other format stuff*
ENDSTYLE END
Result is: 0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0
Can someone please tell me what is wrong, i tried all variation of the line APP FILEDEF raymond DISK WHTWER/whatwere.txt without succes.
Thank you in advanceThis message has been edited. Last edited by: YKK,
7.6. / Win 7 / Excel
November 27, 2009, 09:56 AM
GamP
Try this for FLATTST
APP FILEDEF WHTWER DISK raymond/whatwere.txt
TABLE FILE WHTWER
PRINT CONO01 LOCA01
ON TABLE PCHOLD FORMAT HTML
END
Hope this helps...
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
November 29, 2009, 03:42 PM
Waz
Also take note that your flat file is comma delimited.
Flat files can be many formats.
With this one, you should use SUFFIX=COM
See below:
EX -LINES 5 EDAPUT MASTER,whtwer,CV,FILE
FILENAME=WHATWERE, SUFFIX=COM
SEGMENT=BASE, SEGTYPE=S1, $
FIELDNAME=CONO01, ALIAS=F01, USAGE=A5, $
FIELDNAME=LOCA01, ALIAS=F02, USAGE=A12, $
EX -LINES 13 EDAPUT FOCTEMP,whtwer,CV,FILE
'01','CENTERZIP'
'01','CENTERSB'
'01','CENTERTP'
'01','EASTZIP'
'01','EASTSB'
'01','EASTTP'
'01','WESTZIP'
'01','WESTSB'
'01','WESTTP'
'01','EXPORTZIP'
'01','EXPORTSB'
'01','EXPORTTP'
FILEDEF whtwer DISK whtwer.ftm
SET PCOMMA = ON
-RUN
TABLE FILE WHTWER
PRINT *
END