As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.
Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.
Read-Only TopicGo
Search
Notify
Admin
New PM!
Silver Member posted July 22, 2008 10:54 AM
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
Guru Can you please post the stylesheet?
WebFOCUS 7.6.6/TomCat/Win2k3
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003
IP
Silver Member 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
Expert 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
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005
IP
Silver Member Is that what you wanted? Thanks for you help!!!!
WebFocus 7.6.4 SQL HTML and Excel
Expert 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
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005
IP
Silver Member 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
Expert 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
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005
IP
Silver Member 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
Virtuoso 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
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004
IP
Master 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
Posts: 755 | Location: TX | Registered: September 25, 2007
IP
Virtuoso 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
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005
IP
Expert 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
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006
IP
Silver Member Thank you.
WebFocus 7.6.4 SQL HTML and Excel
Expert 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
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005
IP
Virtuoso 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
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005
IP
Expert 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!
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006
IP
Silver Member 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
Expert 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!
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006
IP
Silver Member Does anyone know where I can find the reference to write everything on one line?
Thanks,
WebFocus 7.6.4 SQL HTML and Excel
Expert 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
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006
IP
Silver Member Thanks so much for the info...
WebFocus 7.6.4 SQL HTML and Excel
Guru 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
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003
IP
Please Wait. Your request is being processed...
Read-Only TopicCopyright © 1996-2020 Information Builders