Focal Point
(FOC3209) UNKNOWN KEYWORD IN STYLESHEET FILE AT LINE 930: 0XD;0XA;
July 22, 2008, 10:54 AM
kfr104 (FOC3209) UNKNOWN KEYWORD IN STYLESHEET FILE AT LINE 930: 0XD;0XA;
I have built this report in the GUI, and when I run it from the GUI interface I recieve this error (FOC3209) UNKNOWN KEYWORD IN STYLESHEET FILE AT LINE 930: 0XD;0XA;. However, when I run the report from the applications screen the report runs fine. I am not sure what the problem is. I did a search on (FOC3209), but was not able to find the answer. Has anyone seen this before?
Thanks,
Here is the code:
-* File Agency_View.fex
JOIN
WEBFOCUS_REPORT_AGENCY_DATA.WEBFOCUS_REPORT_AGENCY_DATA.AGENCYID IN
WEBFOCUS_REPORT_AGENCY_DATA TO MULTIPLE
WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.AGENCYID
IN WEBFOCUS_REPORT_SALES_BY_SUPPLIER AS J0
END
JOIN
WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SUPPLIERID
IN WEBFOCUS_REPORT_AGENCY_DATA TO MULTIPLE
WEBFOCUS_REPORT_SUPPLIER_DATE_LAST.WEBFOCUS_REPORT_SUPPLIER_DATE_LAST.SUPPLIERID
IN WEBFOCUS_REPORT_SUPPLIER_DATE_LAST AS J1
END
DEFINE FILE WEBFOCUS_REPORT_AGENCY_DATA
phone1/A38=EDIT(PHONE, '(999) 999-9999');
fax1/A38=EDIT(FAX, '(999) 999-9999');
Contact/A130=CONTACTFIRSTNAME || ( ' ' | CONTACTLASTNAME );
CityState/A132=CITY || ( ', ' | STATE );
address1/A514=ADDRESS1 || ( ', ' | ADDRESS2);
startdate/MDYY=HDATE( MEMBERSHIPCONTRACTSTARTDATE , 'YYMD');
enddate/MDYY=HDATE( MEMBERSHIPCONTRACTENDDATE , 'YYMD');
startdate/MDYY=HDATE(WEBFOCUS_REPORT_AGENCY_DATA.MEMBERSHIPCONTRACTSTARTDATE, 'YYMD');
enddate/MDYY=HDATE( MEMBERSHIPCONTRACTENDDATE , 'YYMD');
CityStateZip/A145=CityState || ( ' ' | ZIPCODE );
InncerCircle2/A512=DECODE INNERCIRCLE ( 0 No 1 Yes );
Inner/A20=IF INNERCIRCLE EQ '1' THEN 'Inner Circle';
Engagement/A20=IF ENGAGEMENTSTATUS EQ 'Active' THEN 'Engagement';
JVP/A3=IF JVPSTATUS EQ 'Active' THEN 'JVP';
Title/A200='Agency View -' || ( ' ' | AGENCYNAME );
END
TABLE FILE WEBFOCUS_REPORT_AGENCY_DATA
SUM
SALESPREV3/P12CM AS '2005'
SALESPREV2/P12CM AS '2006'
SALESPREV1/P12CM AS '2007'
SALESCURYTD/P12CM AS 'YTD'
CURSALESINFO AS ''
SALESYTDLY/P12CM AS 'YTDLY'
LYSALESINFO AS ''
COMPUTE Variance/D12CM = SALESCURYTD - SALESYTDLY; AS 'YOY,Variance'
SALESCURMTH/P12CM AS 'Current,Month'
SALESCURMTHLY/P12CM AS 'Current,Month LY'
MAX.AGENCYLASTYRMTH/I6 AS 'Agency,Last Report'
MAX.LASTYRMTH/I6 AS 'Supplier,Last Report'
BY TOTAL HIGHEST SALESCURYTD NOPRINT
BY SUPPLIERID AS 'Code'
BY SUPPLIERNAME AS 'Name'
ON TABLE SUBHEAD
" <Title "
" <+0>Run Date: &DATE<+0> "
" <+0>Contact Info<+0> <+0> <+0> <+0>Agency Info<+0> "
" <+0>Contact:<+0> <Contact <Inner <+0>TAN:<+0> <+0>&Tan<+0> "
" <+0>Agency:<+0> <AGENCYNAME <Engagement <+0>IATA:<+0> <INDUSTRYID "
" <+0>Address:<+0> <address1 <JVP <+0>Type:<+0> <AGENCYTYPE "
" <+0>City/State/Zip:<+0> <CityStateZip <+0> <+0> <+0>Status:<+0> <MEMBERSHIPSTATUS "
" <+0>Phone:<+0> <phone1 <+0> <+0> <+0>Territory:<+0> <TERRITORY "
" <+0>Fax:<+0> <fax1 <+0> <+0> <+0>Affiliation Scan Date:<+0> <AFFILIATIONLETTERSCANDATE "
" <+0>Email:<+0> <EMAIL <+0> <+0> <+0># of Branches:<+0> <BRANCHCNT "
" <+0>Website:<+0> <WEBSITE <+0> <+0> <+0>Join Date:<+0> <startdate "
" <+0>Own The Member:<+0> <EMPLOYEE_NAME <+0> <+0> <+0>End Date:<+0> <enddate "
" <+0> <+0> <+0> <+0> <+0> <+0> <+0>Conference 2008:<+0> <CONF08CNT "
" <+0> <+0> <+0> <+0> <+0> <+0> <+0>Conference 2009:<+0> <CONF09CNT "
ON TABLE SUBFOOT
"*TF stands for Traveled and Future Sales"
"*TO stands for Travel Sales Only"
WHERE AGENCYID EQ &Tan;
WHERE TOTAL ( SALESPREV1 NE 0 ) OR ( SALESCURYTD NE 0 );
ON TABLE SET PAGE-NUM OFF
ON TABLE SUMMARIZE WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESPREV3 WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESPREV2 WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESPREV1 WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESCURYTD WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESYTDLY Variance WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESCURMTH WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESCURMTHLY AS 'TOTAL'
ON TABLE PCHOLD FORMAT &WFFMT.(<HTML,HTML>,<PDF,PDF>,<Excel 2000,EXL2K>).Select type of display output.
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.055556,
RIGHTMARGIN=0.055556,
TOPMARGIN=0.055556,
BOTTOMMARGIN=0.055556,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
GRID=OFF,
FONT='VERDANA',
SIZE=9,
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N10,
SIZE=6,
$
TYPE=DATA,
COLUMN=N8,
SIZE=6,
$
TYPE=DATA,
COLUMN=N11,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N1,
SIZE=8,
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N2,
SIZE=8,
$
TYPE=DATA,
COLUMN=N4,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N5,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N6,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N7,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N9,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N12,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N13,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N14,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N15,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N3,
SIZE=8,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N10,
SIZE=6,
$
TYPE=TITLE,
COLUMN=N8,
SIZE=6,
$
TYPE=TITLE,
COLUMN=N11,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N1,
STYLE=BOLD,
JUSTIFY=LEFT,
$
TYPE=TITLE,
COLUMN=N2,
SIZE=9,
STYLE=BOLD+UNDERLINE,
$
TYPE=TITLE,
COLUMN=N4,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N5,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N6,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N7,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N9,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N12,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N13,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N14,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N15,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N3,
SIZE=9,
STYLE=BOLD+UNDERLINE,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
SIZE=10,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=3,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=4,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
SIZE=11,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
WIDTH=8.250,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=2,
SIZE=9,
JUSTIFY=CENTER,
WIDTH=8.250,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=3,
SIZE=10,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=4,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=5,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=6,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=7,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=9,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=10,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=11,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
SIZE=9,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=2,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
WIDTH=3.500,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=3,
SIZE=9,
JUSTIFY=CENTER,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=4,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=5,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=6,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
WIDTH=3.000,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=7,
SIZE=9,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=9,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=10,
JUSTIFY=LEFT,
WIDTH=3.000,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=11,
JUSTIFY=LEFT,
WIDTH=3.000,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=6,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=7,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=8,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=9,
SIZE=8,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=11,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=FIELD,
ITEM=2,
SIZE=8,
JUSTIFY=CENTER,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=FIELD,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=6,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=7,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=8,
SIZE=8,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=9,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=FIELD,
ITEM=2,
SIZE=8,
JUSTIFY=CENTER,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=FIELD,
ITEM=3,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=FIELD,
ITEM=4,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=6,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=7,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=8,
SIZE=8,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=9,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=FIELD,
ITEM=2,
SIZE=8,
JUSTIFY=CENTER,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=FIELD,
ITEM=3,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=FIELD,
ITEM=4,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=5,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=6,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=7,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=8,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=9,
SIZE=8,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=11,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=FIELD,
ITEM=2,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=FIELD,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=6,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=7,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=8,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=9,
SIZE=8,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=11,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=FIELD,
ITEM=2,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=FIELD,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=6,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=7,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=8,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=9,
SIZE=8,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=11,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=FIELD,
ITEM=2,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=FIELD,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=6,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=7,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=8,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=9,
SIZE=8,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=11,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=FIELD,
ITEM=2,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=FIELD,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=6,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=7,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=8,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=9,
SIZE=8,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=11,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=FIELD,
ITEM=2,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=FIELD,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=2,
SIZE=7,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=6,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=7,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=8,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=9,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=11,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=12,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=FIELD,
ITEM=2,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=4,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=6,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=7,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=8,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=9,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=11,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=4,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=6,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=7,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=8,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=9,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=11,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=9,
$
TYPE=TABFOOTING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=9,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
SIZE=8,
BACKCOLOR='NONE',
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=REPORT,
COLUMN=N1,
SQUEEZE=0.930556,
$
TYPE=REPORT,
COLUMN=N3,
SQUEEZE=3.680556,
$
ENDSTYLE
END
This message has been edited. Last edited by: Kerry , July 24, 2008 10:06 AM WebFocus 7.6.4 SQL HTML and Excel
July 22, 2008, 10:57 AM
Carol Dobson Can you please post the stylesheet?
WebFOCUS 7.6.6/TomCat/Win2k3
July 22, 2008, 11:04 AM
kfr104 ON TABLE SET PAGE-NUM OFF
ON TABLE SUMMARIZE WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESPREV3 WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESPREV2 WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESPREV1 WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESCURYTD WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESYTDLY Variance WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESCURMTH WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESCURMTHLY AS 'TOTAL'
ON TABLE PCHOLD FORMAT &WFFMT.(<HTML,HTML>,<PDF,PDF>,<Excel 2000,EXL2K>).Select type of display output.
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.055556,
RIGHTMARGIN=0.055556,
TOPMARGIN=0.055556,
BOTTOMMARGIN=0.055556,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
GRID=OFF,
FONT='VERDANA',
SIZE=9,
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N10,
SIZE=6,
$
TYPE=DATA,
COLUMN=N8,
SIZE=6,
$
TYPE=DATA,
COLUMN=N11,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N1,
SIZE=8,
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N2,
SIZE=8,
$
TYPE=DATA,
COLUMN=N4,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N5,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N6,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N7,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N9,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N12,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N13,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N14,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N15,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N3,
SIZE=8,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N10,
SIZE=6,
$
TYPE=TITLE,
COLUMN=N8,
SIZE=6,
$
TYPE=TITLE,
COLUMN=N11,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N1,
STYLE=BOLD,
JUSTIFY=LEFT,
$
TYPE=TITLE,
COLUMN=N2,
SIZE=9,
STYLE=BOLD+UNDERLINE,
$
TYPE=TITLE,
COLUMN=N4,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N5,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N6,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N7,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N9,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N12,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N13,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N14,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N15,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N3,
SIZE=9,
STYLE=BOLD+UNDERLINE,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
SIZE=10,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=3,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=4,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
SIZE=11,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
WIDTH=8.250,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=2,
SIZE=9,
JUSTIFY=CENTER,
WIDTH=8.250,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=3,
SIZE=10,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=4,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=5,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=6,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=7,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=9,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=10,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=11,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
SIZE=9,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=2,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
WIDTH=3.500,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=3,
SIZE=9,
JUSTIFY=CENTER,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=4,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=5,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=6,
SIZE=9,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
WIDTH=3.000,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=7,
SIZE=9,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=9,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=10,
JUSTIFY=LEFT,
WIDTH=3.000,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=11,
JUSTIFY=LEFT,
WIDTH=3.000,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=6,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=7,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=8,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=9,
SIZE=8,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=11,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=FIELD,
ITEM=2,
SIZE=8,
JUSTIFY=CENTER,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=FIELD,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=6,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=7,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=8,
SIZE=8,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=9,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=FIELD,
ITEM=2,
SIZE=8,
JUSTIFY=CENTER,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=FIELD,
ITEM=3,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=FIELD,
ITEM=4,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=6,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=7,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=8,
SIZE=8,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=9,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=FIELD,
ITEM=2,
SIZE=8,
JUSTIFY=CENTER,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=FIELD,
ITEM=3,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=FIELD,
ITEM=4,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=5,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=6,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=7,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=8,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=9,
SIZE=8,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=TEXT,
ITEM=11,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=FIELD,
ITEM=2,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=7,
OBJECT=FIELD,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=6,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=7,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=8,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=9,
SIZE=8,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=11,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=FIELD,
ITEM=2,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=8,
OBJECT=FIELD,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=6,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=7,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=8,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=9,
SIZE=8,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=TEXT,
ITEM=11,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=FIELD,
ITEM=2,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=9,
OBJECT=FIELD,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=6,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=7,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=8,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=9,
SIZE=8,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=TEXT,
ITEM=11,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=FIELD,
ITEM=2,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=10,
OBJECT=FIELD,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=6,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=7,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=8,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=9,
SIZE=8,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=TEXT,
ITEM=11,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=FIELD,
ITEM=2,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=11,
OBJECT=FIELD,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=2,
SIZE=7,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=6,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=7,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=8,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=9,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=11,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=TEXT,
ITEM=12,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=12,
OBJECT=FIELD,
ITEM=2,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=4,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=6,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=7,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=8,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=9,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=TEXT,
ITEM=11,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=13,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.125,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=4,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=5,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=6,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=7,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.500,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=8,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=1.500,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=9,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=10,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=TEXT,
ITEM=11,
SIZE=7,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=2.000,
$
TYPE=TABHEADING,
LINE=14,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=9,
$
TYPE=TABFOOTING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=9,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
SIZE=8,
BACKCOLOR='NONE',
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=REPORT,
COLUMN=N1,
SQUEEZE=0.930556,
$
TYPE=REPORT,
COLUMN=N3,
SQUEEZE=3.680556,
$
ENDSTYLE
END
This message has been edited. Last edited by: Kerry , July 24, 2008 10:47 AM WebFocus 7.6.4 SQL HTML and Excel
July 22, 2008, 11:08 AM
Francis Mariani quote:
0XD;0XA;
may have something to do with carriage-return/line-feed.
It appears line 930 is around:
TYPE=TABHEADING,
LINE=8,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
JUSTIFY=RIGHT,
WIDTH=.500,
$
so I would eliminate that clause in the stlyesheet - perhaps something got corrupted when Dev Studio saved the fex file...
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
July 22, 2008, 11:10 AM
kfr104 Is that what you wanted? Thanks for you help!!!!
WebFocus 7.6.4 SQL HTML and Excel
July 22, 2008, 11:23 AM
Francis Mariani I should have said, eliminate the clause, rerun the fex. If that works, re-add the styling from the GUI and rerun.
I hope this works for you.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
July 22, 2008, 11:51 AM
kfr104 Thanks for the info...but that did not work. I have gone in and deleted everything from the header. I reran it and it works. I then went in and just added the grid into the header, but have not typed in any text and this is what I get back (FOC3209) UNKNOWN KEYWORD IN STYLESHEET FILE AT LINE 934: APP DISABLE
WebFocus 7.6.4 SQL HTML and Excel
July 22, 2008, 12:12 PM
Francis Mariani Definitely something funny going on. Disk error perhaps.
I would probably open a case with IBI.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
July 22, 2008, 12:14 PM
kfr104 I am trying to rebuild the header and it keeps giving me different errors. I do not understand why...when I built the same report in managed reporting I never had an issue. I do not understand why this would be any different...
Thanks,
WebFocus 7.6.4 SQL HTML and Excel
July 22, 2008, 02:18 PM
dhagen In 76 there is a new parm in the cgivars.wfs that is probably causing this problem. You might want to open a call with help desk and get an explanation for:
XSL_NEWLINE_DELIM = 0xD;0xA; As Francis said, it has something to do with CR/LF for some operating systems. Might be as simple as checking the ASCII save content option in Dev Studio.
"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
July 23, 2008, 08:59 AM
PBrightwell check your stylesheet, are you missing a comma or a $
Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes
July 23, 2008, 03:04 PM
j.gross Check you subhead -- it has extra (or missing) doublequotes sprinkled throughout:
ON TABLE SUBHEAD
" " <+0>Run Date: &DATE<+0> "
" <+0>Contact Info<+0> <+0> <+0> <+0>Agency Info<+0> "
" <+0>Contact:<+0> TAN:<+0> <+0>&Tan<+0> "
" <+0>Agency:<+0> IATA:<+0> " <+0>Address:<+0> Type:<+0> " <+0>City/State/Zip:<+0> <+0> <+0>Status:<+0> " <+0>Phone:<+0> <+0> <+0>Territory:<+0> " <+0>Fax:<+0> <+0> <+0>Affiliation Scan Date:<+0> " <+0>Email:<+0> <+0> <+0># of Branches:<+0> " <+0>Website:<+0> <+0> <+0>Join Date:<+0> " <+0>Own The Member:<+0> <+0> <+0>End Date:<+0> " <+0> <+0> <+0> <+0> <+0> <+0> <+0>Conference 2008:<+0> " <+0> <+0> <+0> <+0> <+0> <+0> <+0>Conference 2009:<+0>
The total is 17 -- when the count is odd, the line or lines following may be eaten as part of the last chunk of text, leading to a Fine Mess.
This message has been edited. Last edited by: j.gross , July 23, 2008 03:11 PM - Jack Gross WF through 8.1.05
July 23, 2008, 03:11 PM
GinnyJakes Boy, I'd love to see the replies on this post but I only see the first one in partial format.
Does anyone know what is going on?
Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
July 23, 2008, 03:11 PM
kfr104 Thank you.
WebFocus 7.6.4 SQL HTML and Excel
July 23, 2008, 03:15 PM
Francis Mariani kfr104, could you please do us a favour?
Please put the code in your first posting between code tags as in:
[code] your code here
[/code] There appears to be a problem for some Internet Explorer users - they can't view anything past the first posting.
Thanks,
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
July 23, 2008, 03:15 PM
j.gross I had that problem in IE, but it's all visible in Opera.
The first post did not have CODE bookends, and the
<+0> probably threw IE for a loop.
Come to think of it, how DID Ginny reply?
- - -
I guess Microsoft deserves our thanks -- if not for the fact that IE truncated the post at
ON TABLE SUBHEAD
" I wouldn't have looked there
.
This message has been edited. Last edited by: j.gross , July 23, 2008 03:53 PM - Jack Gross WF through 8.1.05
July 24, 2008, 05:55 PM
Waz Could you post the program output.
Make sure you set &ECHO to ALL.
Are you running this from within the Report painter or just from the GUI ?
Waz... Prod: WebFOCUS 7.6.10/8.1.04 Upgrade: WebFOCUS 8.2.07 OS: Linux Outputs: HTML, PDF, Excel, PPT In Focus since 1984 Pity the lost knowledge of an old programmer!
July 25, 2008, 09:07 AM
kfr104 I keep positing the code, but no one can see it. I spoke to support and the reason it will not run in the GUI is becuase there are to many lines in the format. It runs fine from the applications screen.
Thanks,
WebFocus 7.6.4 SQL HTML and Excel
July 25, 2008, 09:23 AM
Waz Thats one thing that I dislike about the painter, the way it write the stylesheet.
The report could be almost 1/4 of the size with compacting the stylesheet items into a single line.
Waz... Prod: WebFOCUS 7.6.10/8.1.04 Upgrade: WebFOCUS 8.2.07 OS: Linux Outputs: HTML, PDF, Excel, PPT In Focus since 1984 Pity the lost knowledge of an old programmer!
July 25, 2008, 09:31 AM
kfr104 Does anyone know where I can find the reference to write everything on one line?
Thanks,
WebFocus 7.6.4 SQL HTML and Excel
July 25, 2008, 09:46 AM
GinnyJakes Thanks to whoever fixed the post.
Jack, I could see the first post partially and had all the buttons so just did a reply.
kfr, to write everything on one line, you'll have to go into the text editor to do it. Also there may be stylesheet blocks that you don't need at all. BUT, if you go back into the painter after doing all that editing, your changes will be lost.
Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
July 25, 2008, 09:54 AM
kfr104 Thanks so much for the info...
WebFocus 7.6.4 SQL HTML and Excel
July 25, 2008, 11:31 AM
Carol Dobson Aha, I can finally see this posting!
Here's an example of how you can change the stylesheet code in the Text Editor.
quote:
TYPE=GRANDTOTAL, SIZE=8, BACKCOLOR='NONE', STYLE=BOLD, JUSTIFY=CENTER, $
Change to:
quote:
TYPE=GRANDTOTAL, SIZE=8, BACKCOLOR=NONE, STYLE=BOLD, JUSTIFY=CENTER,$
I'm finding some issues with large focexecs in 7.6.4 also!
Thanks,
Carol
WebFOCUS 7.6.6/TomCat/Win2k3