[SOLVED] excel compound report/w excel 2003 - Topic

Focal Point Banner

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.

Focal Point Forums

Hop To Forum Categories

WebFOCUS/FOCUS Forum on Focal Point

[SOLVED] excel compound report/w excel 2003

Read-Only Topic

Go

Search

Notify

Tools

Personal Zone	»
Member Directory
Focal Point Forums	»

Add to My Favorites

Printer Friendly Format

[SOLVED] excel compound report/w excel 2003

Silver Member

posted

Hello all

I have a Question:

I have a compound excel report, and I have office 2003. my two reports work when I produce them separately however when I produce them together with the following syntax, they bomb. Any suggestions for me?
rpt1: ON TABLE PCHOLD FORMAT EXL2K OPEN SHEETNUM1
rpt2: ON TABLE PCHOLD FORMAT EXL2K SHEETNUM2

this is my error: (FOC3291) TEMPLATE FILE: Template specification error
(FOC009) INCOMPLETE REQUEST STATEMENT
(FOC3298) ERROR FOUND IN A COMPOUND REPORT
Compound Report is TERMINATING.....

This message has been edited. Last edited by: Kerry,

Posts: 38 | Location: Atlanta | Registered: June 14, 2005

Report This Post

Platinum Member

posted

Can you please show the code?

Are you closing the compound report?

Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats

Posts: 121 | Location: California | Registered: June 19, 2008

Report This Post

Ignored post by prodrigu posted

Silver Member

posted

  
-* File gtas_rpt_xwalk_db_dwnload_r.fex
-*--------------------------------------------------------------------
-* File Name:    gtas_rpt_xwalk_db_dwnload_r.fex                     *
-* Description:  This file generates the Crosswalk database Download *
-*               Report for the USSGL Crosswalks Module              *
-*                                                                   *
-* Date: 05/16/2011                                                  *
-* Author: Timothy Brydie                                            *
-*--------------------------------------------------------------------
-*********************************************************************
-* Change/Update/Add                                                 *
-*                                                                   *
-* Date       BY                    Description of Change            *
-* ----       -------------------   ---------------------------------***********************
-* 05/16/2011 Timothy Brydie        Initial program Creation                               *
-*******************************************************************************************
-DEFAULTH &TABLE_NAME = 'XWLKDL1';
-DEFAULT &RPT_ID = '71';
-DEFAULT &FORMAT  = 'EXL2K';
-*
-*------------------------------------------
-* Include environment file                *
-*------------------------------------------
-INCLUDE GTAS_ENVIRONMENT
-*
-*------------------------------------------
-* Include report setting file             *
-*------------------------------------------
-INCLUDE GTAS_REPORT_SETTINGS
-*
-*------------------------------------------
-* Include the timestamp file              *
-*------------------------------------------
-INCLUDE GTAS_CURRENT_TIMESTAMP
-*

-*
-*USE THIS TO TEST THE ERROR ROUTINES/CHANGE THIS TO ZERO TO TEST
-*
-*TABLE FILE &TABLE_NAME
-*PRINT *
-*BY RPT_ID
-*BY RELEASE
-*BY PART
-*BY SGLFY
-*ON TABLE HOLD AS HDFLG FORMAT ALPHA
-*END
-*-RUN
-*? HOLD HDFLG
-*-EXIT
-*DEFINE FILE WLK1DATA
TABLE FILE &TABLE_NAME
PRINT *
DATA_FLAG NOPRINT
BY DATA_FLAG
BY RELEASE
BY PART
BY SGLFY
ON TABLE HOLD AS HDFLG FORMAT ALPHA
END
-RUN
-*-EXIT
-*
-READ HDFLG &DATA_FLAG.A1. &RELEASE.A22. &PART.A10. &SGLFY.A4.
-*-*

-SET &DATA_FLAG = TRUNCATE('&DATA_FLAG.EVAL');
-*
-SET &RELEASE = LJUST(22, '&RELEASE.EVAL', 'A22');
-SET &RELEASE = TRUNCATE('&RELEASE.EVAL');
-TYPE RELEASE   ==== '&RELEASE'
-
-*
-SET &PART = LJUST(10, '&PART.EVAL', 'A10');
-SET &PART = TRUNCATE('&PART.EVAL');
-*
-SET &SGLFY = LJUST(10, '&SGLFY.EVAL', 'A4');
-SET &SGLFY = TRUNCATE('&SGLFY.EVAL');

-*
-TYPE DATA_FLAG ==== '&DATA_FLAG'
-TYPE RELEASE   ==== '&RELEASE'
-TYPE PART      ==== '&PART'
-*-EXIT
-*------------------------------------------
-* Get report title and other information  *
-*------------------------------------------
-INCLUDE GTAS_GET_COMPNENT_INFO
-RUN
-*------------------------------------------
-* Read the amper variable &DATA_FLAG.     *
-*------------------------------------------
-IF '&DATA_FLAG.EVAL' EQ 'N' THEN GOTO NODATA;
-*
-*
-*------------------------------------------
-* Get the RELEASE LABEL value             *
-*------------------------------------------
EXEC GTAS_GET_RELEASE_LABEL RELEASE='&RELEASE'
-RUN
-TYPE RELEASE_LABEL = '&&RELEASE_LABEL'
-*
-*------------------------------------------
-* Get the SFL_FY value                    *
-*------------------------------------------
EXEC GTAS_GET_FY RELEASE='&RELEASE', PART='&PART'
-RUN
-TYPE SFL_FY = '&&SGL_FY'
-*-EXIT
DEFINE FILE &TABLE_NAME
SGL_ATTR_ID_A1/A22 = FTOA(SGL_ATTR_ID, '(D20.2)', SGL_ATTR_ID_A1);
SGL_ATTR_ID_A/A22 = LJUST(22, SGL_ATTR_ID_A1, SGL_ATTR_ID_A);
SGL_ATTR_SHORT_NAME_NEW/A50 = SGL_ATTR_SHORT_NAME;
END
-RUN
-*
TABLE FILE &TABLE_NAME
SUM SGL_ATTR_ID_A  NOPRINT
BY SGL_ATTR_ID_A
BY SGL_ATTR_SHORT_NAME_NEW
ON TABLE HOLD AS WLK2DATA
END
-RUN
-*-EXIT
-*------------------------------------------
-* From the hold file WLK2DATA, get the    *
-* values of the SGL_ATTR_ID_A in a string *
-*------------------------------------------
-RUN
-SET &L3     = &LINES;
-SET &L4     = &LINES;
-SET &C      = 1;
-SET &BYSTR1 = '';
-SET &JSTR1  = '';
-*
-*********************************************************************************************************
-*A "A_" is attached preceeding every attribute in the file.                                             *
-*This loop continues until attribute is processed has the short name concated with it-assigned to &JSTR *
-*********************************************************************************************************
-REPEAT L3 &L3 TIMES
-READ WLK2DATA &SGL_ATTR_ID_A1.A22 &ST_NN_A1.A50.
-SET &SGL_ATTR_ID_A2 = LJUST(22, '&SGL_ATTR_ID_A1.EVAL', 'A22');
-SET &SGL_ATTR_ID_A = 'A_' || TRUNCATE('&SGL_ATTR_ID_A2.EVAL');
-TYPE SGL_ATTR_ID_A = '&SGL_ATTR_ID_A'
-*
-SET &ST_NN_A2 =  LJUST(50, '&ST_NN_A1.EVAL', 'A50');
-SET &ST_NN_A =  TRUNCATE('&ST_NN_A2.EVAL');
-*
-SET &BYSTR1 = '&BYSTR1.EVAL' | 'BY &SGL_ATTR_ID_A.EVAL   ' ;
-SET &JSTR1  = '&JSTR1.EVAL' | ' &SGL_ATTR_ID_A.EVAL AS #&ST_NN_A.EVAL# ' ;
-TYPE  JSTR1 ==== '&JSTR1'
-SET &C = &C + 1;
-L3
-*
-SET &LEN = &JSTR1.LENGTH;
-SET &JSTR1 = STRREP (&LEN, '&JSTR1.EVAL', 1, '#', 1, '''', &LEN, 'A&LEN.EVAL');
-*
-TYPE BYSTR1 ==== '&BYSTR1'
-TYPE  JSTR1 ==== '&JSTR1'
-*

-*TABLE FILE WLK1DATA
TABLE FILE &TABLE_NAME
-*SUM SGL_DOM_VALUE AS 'A_'
PRINT SGL_DOM_VALUE AS 'A_'
ACROSS SGL_ATTR_ID_A
-*ACROSS SGL_ATTR_SHORT_NAME  AS ''
BY STMT_TITLE
BY STMT_DETAIL_LABEL
BY STMT_DETAIL_DESCR
BY STMT_DETAIL_TYPE
BY STMT_DETAIL_NORM_BAL
BY RECIP_CAT
BY SGL_ACCT
BY FMS_2108_BUS_LINE
ON TABLE HOLD AS WLK3DATA
END
-RUN
-*
-*------------------------------------------
-* If the TABLE_NAME is not passed then    *
-* do not execute the report               *
-*------------------------------------------
-IF '&TABLE_NAME.EVAL' EQ 'FOC_NONE' THEN GOTO ERR;
-*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-*THIS SECTION WILL HANDEL THE "NO DATA" CONDITION.*
-*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-*
-OKTOGO
-*
-*------------------------------------------
-* If the TABLE_NAME is not passed then    *
-* do not execute the report               *
-*------------------------------------------
-IF '&TABLE_NAME.EVAL' EQ 'FOC_NONE' THEN GOTO ERR;
-*-GOTO TIMOTHY
-*
-*------------------------------------------
-* Define fields required in the report    *
-*------------------------------------------
DEFINE FILE WLK3DATA
FY_TXT/A40 = 'Fiscal Year ' | '&SGLFY' | ' Reporting';
PART_TXT/A40 = 'Part ' | '&PART.EVAL' ;
-*
STMT_DETAIL_TYPE1/A5 = DECODE STMT_DETAIL_TYPE (T 'TITLE'
                                                S 'USSGL'
                                                C 'CACL');

END
-RUN
-*------------------------------------------
-* Generate reports                        *
-*------------------------------------------
TABLE FILE WLK3DATA
PRINT
STMT_TITLE                  AS 'Crosswalk Name'
STMT_DETAIL_LABEL           AS 'Line, No'
STMT_DETAIL_DESCR           AS 'Line Title'
STMT_DETAIL_TYPE1           AS 'Line Type'
STMT_DETAIL_NORM_BAL        AS 'Line Norm Balance'
RECIP_CAT                   AS 'Reciprocal Category '
SGL_ACCT                    AS 'USSGL Account'
&JSTR1.EVAL
FMS_2108_BUS_LINE           AS 'Business Line'
WHERE READLIMIT EQ 10

-*ON TABLE HOLD AS WLK4DATA FORMAT FOCUS
-*END
-*-RUN
-*-EXIT
-*
-*------------------------------------------
-* Based on the format apply style         *
-*------------------------------------------
-IF '&FORMAT.EVAL' EQ 'HTML' THEN GOTO HTMFMT ELSE
-IF '&FORMAT.EVAL' EQ 'PDF'  THEN GOTO PDFFMT ELSE
-IF '&FORMAT.EVAL' EQ 'EXL2K' THEN GOTO EXLFMT ;
-*
-*------------------------------------------
-* EXCEL Formatting                         *
-*------------------------------------------
-EXLFMT
HEADING
"<PART_TXT<FY_TXT"
" "
"&RPT_TITLE_1"
" "
FOOTING
-*
ON TABLE NOTOTAL
-*ON TABLE PCHOLD FORMAT EXL2K 
-*ON TABLE PCHOLD FORMAT PDF &OPEN &NOBREAK
ON TABLE PCHOLD FORMAT EXL2K OPEN SHEETNUM1
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=9,GRID=ON,
$
-*TYPE=HEADING,WRAP=1,$
TYPE=HEADING,HEADALIGN=BODY,$
-*********
-*Heading*
TYPE=HEADING,LINE=1, ITEM=1,JUSTIFY=LEFT,COLSPAN=12,STYLE=BOLD,$
TYPE=HEADING,LINE=1,OBJECT=FIELD,ITEM=2,JUSTIFY=RIGHT,STYLE=BOLD,$
TYPE=HEADING,LINE=2,ITEM=1,JUSTIFY=LEFT,COLSPAN=9,STYLE=BOLD,$
TYPE=HEADING,LINE=2,ITEM=2, POSITION=9.95,JUSTIFY=RIGHT,STYLE=BOLD,$
TYPE=HEADING,LINE=3,JUSTIFY=CENTER,STYLE=BOLD,COLSPAN=13,$

-************************
-*STYLING FOR THE TITLES*
-************************
TYPE=TITLE,  COLUMN=N1,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N2,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N3,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N4,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N5,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N6,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N7,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N8,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N9,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N10,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N11,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N12,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N13,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N14,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N15,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N16,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N17,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N18,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
-*TYPE=TITLE,  COLUMN=N10,JUSTIFY=CENTER,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
-**********************
-*STYLING FOR THE DATA*
-**********************
-*TYPE=DATA,COLUMN=N1, BORDER-COLOR='SILVER',BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT, $
TYPE=DATA,COLUMN=N1,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT, $
TYPE=DATA,COLUMN=N2,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1.5,WRAP=1.5,$
TYPE=DATA,COLUMN=N3,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT, WIDTH=2,WRAP=2,$
TYPE=DATA,COLUMN=N4,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,$
TYPE=DATA,COLUMN=N5,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1.0,WRAP=1.0,$
TYPE=DATA,COLUMN=N6,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N7,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N8,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N9,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N10, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N11, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N12, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N13, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N14, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N15, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N16, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N17, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N18, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
-*TIME STAMP IN FAR RIGHT CORNER
TYPE=FOOTING,LINE=1,OBJECT=TEXT,ITEM=1,JUSTIFY=RIGHT,position=1.2, $
ENDSTYLE
END
-RUN
-EXIT
-*------------------------------------------------
-* Generate reports the second (2nd) report      *
-*------------------------------------------------
-*-TIMOTHY
-SET &TABLE_NAME1 = &TABLE_NAME || '_C';
-TYPE &&&= &TABLE_NAME1
-*-EXIT
-*------------------------------------------
-* Define fields required in the report    *
-*------------------------------------------
DEFINE FILE &TABLE_NAME1
FY_TXT/A40 = 'Fiscal Year ' | '&SGLFY' | ' Reporting';
PART_TXT/A40 = 'Part ' | '&PART.EVAL' ;
-*
-*STMT_DETAIL_TYPE1/A5 = DECODE STMT_DETAIL_TYPE (T 'TITLE'
-*                                                S 'USSGL'
-*                                                C 'CACL');

END
-RUN
-*

TABLE FILE &TABLE_NAME1
PRINT
CROSSWALKNAME
CALCLINE
CALCLINETITLE
ASSIGNEDLINE
ASSIGNEDLINETITLE
ASSIGNEDLINESTATEMENT
-*WHERE READLIMIT EQ 10
-*END
-*-RUN
-*-EXIT
-*
-*------------------------------------------
-* Based on the format apply style         *
-*------------------------------------------
-IF '&FORMAT.EVAL' EQ 'HTML' THEN GOTO HTMFMT ELSE
-IF '&FORMAT.EVAL' EQ 'PDF'  THEN GOTO PDFFMT ELSE
-IF '&FORMAT.EVAL' EQ 'EXL2K' THEN GOTO EXLFMT ;
-*-EXIT
-*
-*------------------------------------------
-* EXCEL Formatting                         *
-*------------------------------------------
-EXLFMT
HEADING
"<PART_TXT<FY_TXT"
" "
"&RPT_TITLE_1"
" "
FOOTING
-*
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K SHEETNUM2
-*ON TABLE PCHOLD FORMAT EXL2K 
-*ON TABLE PCHOLD FORMAT PDF &OPEN &NOBREAK
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=9,GRID=ON,
$
-*TYPE=HEADING,WRAP=1,$
TYPE=HEADING,HEADALIGN=BODY,$
-*********
-*Heading*
TYPE=HEADING,LINE=1, ITEM=1,JUSTIFY=LEFT,COLSPAN=12,STYLE=BOLD,$
TYPE=HEADING,LINE=1,OBJECT=FIELD,ITEM=2,JUSTIFY=RIGHT,STYLE=BOLD,$
TYPE=HEADING,LINE=2,ITEM=1,JUSTIFY=LEFT,COLSPAN=9,STYLE=BOLD,$
TYPE=HEADING,LINE=2,ITEM=2, POSITION=9.95,JUSTIFY=RIGHT,STYLE=BOLD,$
TYPE=HEADING,LINE=3,JUSTIFY=CENTER,STYLE=BOLD,COLSPAN=13,$

-************************
-*STYLING FOR THE TITLES*
-************************
TYPE=TITLE,  COLUMN=N1,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N2,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N3,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N4,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N5,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N6,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N7,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N8,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N9,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N10,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N11,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N12,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N13,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N14,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N15,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N16,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N17,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N18,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
-*TYPE=TITLE,  COLUMN=N10,JUSTIFY=CENTER,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
-**********************
-*STYLING FOR THE DATA*
-**********************
-*TYPE=DATA,COLUMN=N1, BORDER-COLOR='SILVER',BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT, $
TYPE=DATA,COLUMN=N1,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT, $
TYPE=DATA,COLUMN=N2,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1.5,WRAP=1.5,$
TYPE=DATA,COLUMN=N3,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT, WIDTH=2,WRAP=2,$
TYPE=DATA,COLUMN=N4,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,$
TYPE=DATA,COLUMN=N5,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1.0,WRAP=1.0,$
TYPE=DATA,COLUMN=N6,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N7,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N8,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N9,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N10, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N11, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N12, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N13, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N14, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N15, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N16, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N17, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N18, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
-*TIME STAMP IN FAR RIGHT CORNER
TYPE=FOOTING,LINE=1,OBJECT=TEXT,ITEM=1,JUSTIFY=RIGHT,position=1.2, $
ENDSTYLE
END
-RUN
-GOTO RPTEND
-*------------------------------------------
-* Handle empty report                     *
-*------------------------------------------
-NODATA
-*
-*------------------------------------------
-* Get the RELEASE LABEL value             *
-*------------------------------------------
EXEC GTAS_GET_RELEASE_LABEL RELEASE='&RELEASE'
-RUN
-TYPE RELEASE_LABEL = '&&RELEASE_LABEL'
-*
-*------------------------------------------
-* Get the SFL_FY value                    *
-*------------------------------------------
EXEC GTAS_GET_FY RELEASE='&RELEASE', PART='&PART'
-RUN
-TYPE SFL_FY = '&&SGL_FY'
-*-EXIT

-*
-*------------------------------------------
-* Generate report                         *
-*------------------------------------------
TABLE FILE &TABLE_NAME
PRINT
DATA_FLAG NOPRINT
-*
-*------------------------------------------
-* Based on the format apply style         *
-*------------------------------------------
-IF '&FORMAT.EVAL' EQ 'HTML' THEN GOTO HTMFMT ELSE
-IF '&FORMAT.EVAL' EQ 'PDF'  THEN GOTO PDFFMT ELSE
-IF '&FORMAT.EVAL' EQ 'EXL2K' THEN GOTO EXLFMTE ;
-*-EXIT
-*
-*------------------------------------------
-* EXCEL Formatting                         *
-*------------------------------------------
-EXLFMTE
HEADING
"<PART_TXT<FY_TXT"
" "
"&RPT_TITLE_1"
" "
FOOTING
-*
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K 
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=9,GRID=ON,
$
-*TYPE=HEADING,WRAP=1,$
TYPE=HEADING,HEADALIGN=BODY,$
-*********
-*Heading*
TYPE=HEADING,LINE=1, ITEM=1,JUSTIFY=LEFT,COLSPAN=12,STYLE=BOLD,$
TYPE=HEADING,LINE=1,OBJECT=FIELD,ITEM=2,JUSTIFY=RIGHT,STYLE=BOLD,$
TYPE=HEADING,LINE=2,ITEM=1,JUSTIFY=LEFT,COLSPAN=9,STYLE=BOLD,$
TYPE=HEADING,LINE=2,ITEM=2, POSITION=9.95,JUSTIFY=RIGHT,STYLE=BOLD,$
TYPE=HEADING,LINE=3,JUSTIFY=CENTER,STYLE=BOLD,COLSPAN=13,$

-************************
-*STYLING FOR THE TITLES*
-************************
TYPE=TITLE,  COLUMN=N1,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N2,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N3,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N4,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N5,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N6,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N7,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N8,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N9,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N10,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N11,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N12,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N13,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N14,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N15,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N16,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N17,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N18,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
-*TYPE=TITLE,  COLUMN=N10,JUSTIFY=CENTER,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
-**********************
-*STYLING FOR THE DATA*
-**********************
-*TYPE=DATA,COLUMN=N1, BORDER-COLOR='SILVER',BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT, $
TYPE=DATA,COLUMN=N1,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT, $
TYPE=DATA,COLUMN=N2,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1.5,WRAP=1.5,$
TYPE=DATA,COLUMN=N3,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT, WIDTH=2,WRAP=2,$
TYPE=DATA,COLUMN=N4,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,$
TYPE=DATA,COLUMN=N5,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1.0,WRAP=1.0,$
TYPE=DATA,COLUMN=N6,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N7,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N8,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N9,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N10, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N11, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N12, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N13, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N14, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N15, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N16, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N17, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N18, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
-*TIME STAMP IN FAR RIGHT CORNER
TYPE=FOOTING,LINE=1,OBJECT=TEXT,ITEM=1,JUSTIFY=RIGHT,position=1.2, $
ENDSTYLE
END
-RUN
-*
-*------------------------------------------
-* End of the module                       *
-*------------------------------------------
-RPTEND

-*-RPTEND

Posts: 38 | Location: Atlanta | Registered: June 14, 2005

Report This Post

Ignored post by tlbrydie posted

Platinum Member

posted

Where are you closing the compound report?

Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats

Posts: 121 | Location: California | Registered: June 19, 2008

Report This Post

Ignored post by prodrigu posted

Silver Member

posted

I did not close because the doc said it was implicit. I think I did close physically in my trial..but let me give it another try.

Thanks for looking at it for me.

Posts: 38 | Location: Atlanta | Registered: June 14, 2005

Report This Post

Ignored post by tlbrydie posted

Silver Member

posted

I used the following:
rpt1: ON TABLE PCHOLD FORMAT EXL2K OPEN SHEETNUM1

rpt2: ON TABLE PCHOLD FORMAT EXL2K CLOSE SHEETNUM2

my error is:
(FOC3291) TEMPLATE FILE: Template specification error
(FOC009) INCOMPLETE REQUEST STATEMENT
(FOC3298) ERROR FOUND IN A COMPOUND REPORT
Compound Report is TERMINATING.....
BYPASSING TO END OF COMMAND

the error is displayed after the -run after my stylesheet for rpt1

Posts: 38 | Location: Atlanta | Registered: June 14, 2005

Report This Post

Ignored post by tlbrydie posted

Platinum Member

posted

I see you have an -EXIT right before where it says "Generate reports the second (2nd) report".
Could that be causing the error?

Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats

Posts: 121 | Location: California | Registered: June 19, 2008

Report This Post

Ignored post by prodrigu posted

Silver Member

posted

Naw..That was just left over from when I tested the two reports individually. That has since been commented out. Do you have any ideal about the "Template" error that I'm getting?

Posts: 38 | Location: Atlanta | Registered: June 14, 2005

Report This Post

Ignored post by tlbrydie posted

Platinum Member

posted

Are you using Templates to format the excel report? If you are it looks like the error is stating you are calling the template wrong.

If you are trying to use a template to format the excel I thought it should look like the below code.

ON TABLE PCHOLD FORMAT EXL2K TEMPLATE 'template_name' SHEETNUMBER 1

Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats

Posts: 121 | Location: California | Registered: June 19, 2008

Report This Post

Ignored post by prodrigu posted

Virtuoso

posted

quote:
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$

in this part you should ad an extra line
it says
TITLE="wathever",

	*Frank*
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7

Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006

Report This Post

Ignored post by FrankDutch posted

Silver Member

posted

ok thanks Frank...for the title information...if only I could get the report to display i want. As for the template information. I'm not producing any templates...I just want a two tabbed report

Posts: 38 | Location: Atlanta | Registered: June 14, 2005

Report This Post

Ignored post by tlbrydie posted

Platinum Member

posted

hi,

Why are you using SHEETNUMBER1/2 in the code...that attribute is used when you have a template file.

If you want a compound excel report on 2 tabs just say OPEN on one and CLOSE on the other...
OPEN NOBREAK will give both the reports on same tab.

thanks
Sashanka

WF 7.7.03/Windows/HTML,PDF,EXL
POC/local Dev Studio 7.7.03 & 7.6.11

Posts: 103 | Registered: June 12, 2009

Report This Post

Ignored post by Severus.snape posted

Virtuoso

posted

severus is right

the title just give the sheets a name
and you also can use the BYTOC command to split the report on the first byfield

	*Frank*
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7

Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006

Report This Post

Ignored post by FrankDutch posted

Platinum Member

posted

Try this

rpt1:
ON TABLE PCHOLD FORMAT EXL2K OPEN
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,
GRID=ON,
TITLETEXT='SHEETNUM1',
$

rpt2:
ON TABLE PCHOLD FORMAT EXL2K CLOSE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,
GRID=ON,
TITLETEXT='SHEETNUM2',
$

Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats

Posts: 121 | Location: California | Registered: June 19, 2008

Report This Post

Ignored post by prodrigu posted

Silver Member

posted

Snap Thanks for chiming in. that explains why I was getting the template error. but as you can see by my newly attached code I've tried allot of things. I've gotten this to work (2 tabs) with the car file, but those reports had no stylesheet information. So I removed the stylesheet info from my code..i got the same results.

  -* File gtas_rpt_xwalk_db_dwnload_r.fex
-*--------------------------------------------------------------------
-* File Name:    gtas_rpt_xwalk_db_dwnload_r.fex                     *
-* Description:  This file generates the Crosswalk database Download *
-*               Report for the USSGL Crosswalks Module              *
-*                                                                   *
-* Date: 05/16/2011                                                  *
-* Author: Timothy Brydie                                            *
-*--------------------------------------------------------------------
-*********************************************************************
-* Change/Update/Add                                                 *
-*                                                                   *
-* Date       BY                    Description of Change            *
-* ----       -------------------   ---------------------------------***********************
-* 05/16/2011 Timothy Brydie        Initial program Creation                               *
-*******************************************************************************************
-DEFAULTH &TABLE_NAME = 'XWLKDL1';
-DEFAULT &RPT_ID = '71';
-DEFAULT &FORMAT  = 'EXL2K';
-SET &TABLE_NAME1 = &TABLE_NAME || '_C';
-*
-*------------------------------------------
-* Include environment file                *
-*------------------------------------------
-INCLUDE GTAS_ENVIRONMENT
-*
-*------------------------------------------
-* Include report setting file             *
-*------------------------------------------
-INCLUDE GTAS_REPORT_SETTINGS
-*
-*------------------------------------------
-* Include the timestamp file              *
-*------------------------------------------
-INCLUDE GTAS_CURRENT_TIMESTAMP
-*

-*
-*USE THIS TO TEST THE ERROR ROUTINES/CHANGE THIS TO ZERO TO TEST
-*
-*TABLE FILE &TABLE_NAME
-*PRINT *
-*BY RPT_ID
-*BY RELEASE
-*BY PART
-*BY SGLFY
-*ON TABLE HOLD AS HDFLG FORMAT ALPHA
-*END
-*-RUN
-*? HOLD HDFLG
-*-EXIT
-*DEFINE FILE WLK1DATA
TABLE FILE &TABLE_NAME
PRINT *
DATA_FLAG NOPRINT
BY DATA_FLAG
BY RELEASE
BY PART
BY SGLFY
ON TABLE HOLD AS HDFLG FORMAT ALPHA
END
-RUN
-*-EXIT
-*
-READ HDFLG &DATA_FLAG.A1. &RELEASE.A22. &PART.A10. &SGLFY.A4.
-*-*

-SET &DATA_FLAG = TRUNCATE('&DATA_FLAG.EVAL');
-*
-SET &RELEASE = LJUST(22, '&RELEASE.EVAL', 'A22');
-SET &RELEASE = TRUNCATE('&RELEASE.EVAL');
-TYPE RELEASE   ==== '&RELEASE'
-
-*
-SET &PART = LJUST(10, '&PART.EVAL', 'A10');
-SET &PART = TRUNCATE('&PART.EVAL');
-*
-SET &SGLFY = LJUST(10, '&SGLFY.EVAL', 'A4');
-SET &SGLFY = TRUNCATE('&SGLFY.EVAL');

-*
-TYPE DATA_FLAG ==== '&DATA_FLAG'
-TYPE RELEASE   ==== '&RELEASE'
-TYPE PART      ==== '&PART'
-*-EXIT
-*------------------------------------------
-* Get report title and other information  *
-*------------------------------------------
-INCLUDE GTAS_GET_COMPNENT_INFO
-RUN
-*------------------------------------------
-* Read the amper variable &DATA_FLAG.     *
-*------------------------------------------
-IF '&DATA_FLAG.EVAL' EQ 'N' THEN GOTO NODATA;
-*
-*
-*------------------------------------------
-* Get the RELEASE LABEL value             *
-*------------------------------------------
EXEC GTAS_GET_RELEASE_LABEL RELEASE='&RELEASE'
-RUN
-TYPE RELEASE_LABEL = '&&RELEASE_LABEL'
-*
-*------------------------------------------
-* Get the SFL_FY value                    *
-*------------------------------------------
EXEC GTAS_GET_FY RELEASE='&RELEASE', PART='&PART'
-RUN
-TYPE SFL_FY = '&&SGL_FY'
-*-EXIT
DEFINE FILE &TABLE_NAME
SGL_ATTR_ID_A1/A22 = FTOA(SGL_ATTR_ID, '(D20.2)', SGL_ATTR_ID_A1);
SGL_ATTR_ID_A/A22 = LJUST(22, SGL_ATTR_ID_A1, SGL_ATTR_ID_A);
SGL_ATTR_SHORT_NAME_NEW/A50 = SGL_ATTR_SHORT_NAME;
END
-RUN
-*
TABLE FILE &TABLE_NAME
SUM SGL_ATTR_ID_A  NOPRINT
BY SGL_ATTR_ID_A
BY SGL_ATTR_SHORT_NAME_NEW
ON TABLE HOLD AS WLK2DATA
END
-RUN
-*-EXIT
-*------------------------------------------
-* From the hold file WLK2DATA, get the    *
-* values of the SGL_ATTR_ID_A in a string *
-*------------------------------------------
-RUN
-SET &L3     = &LINES;
-SET &L4     = &LINES;
-SET &C      = 1;
-SET &BYSTR1 = '';
-SET &JSTR1  = '';
-*
-*********************************************************************************************************
-*A "A_" is attached preceeding every attribute in the file.                                             *
-*This loop continues until attribute is processed has the short name concated with it-assigned to &JSTR *
-*********************************************************************************************************
-REPEAT L3 &L3 TIMES
-READ WLK2DATA &SGL_ATTR_ID_A1.A22 &ST_NN_A1.A50.
-SET &SGL_ATTR_ID_A2 = LJUST(22, '&SGL_ATTR_ID_A1.EVAL', 'A22');
-SET &SGL_ATTR_ID_A = 'A_' || TRUNCATE('&SGL_ATTR_ID_A2.EVAL');
-TYPE SGL_ATTR_ID_A = '&SGL_ATTR_ID_A'
-*
-SET &ST_NN_A2 =  LJUST(50, '&ST_NN_A1.EVAL', 'A50');
-SET &ST_NN_A =  TRUNCATE('&ST_NN_A2.EVAL');
-*
-SET &BYSTR1 = '&BYSTR1.EVAL' | 'BY &SGL_ATTR_ID_A.EVAL   ' ;
-SET &JSTR1  = '&JSTR1.EVAL' | ' &SGL_ATTR_ID_A.EVAL AS #&ST_NN_A.EVAL# ' ;
-TYPE  JSTR1 ==== '&JSTR1'
-SET &C = &C + 1;
-L3
-*
-SET &LEN = &JSTR1.LENGTH;
-SET &JSTR1 = STRREP (&LEN, '&JSTR1.EVAL', 1, '#', 1, '''', &LEN, 'A&LEN.EVAL');
-*
-TYPE BYSTR1 ==== '&BYSTR1'
-TYPE  JSTR1 ==== '&JSTR1'
-*

-*TABLE FILE WLK1DATA
TABLE FILE &TABLE_NAME
-*SUM SGL_DOM_VALUE AS 'A_'
PRINT SGL_DOM_VALUE AS 'A_'
ACROSS SGL_ATTR_ID_A
-*ACROSS SGL_ATTR_SHORT_NAME  AS ''
BY STMT_TITLE
BY STMT_DETAIL_LABEL
BY STMT_DETAIL_DESCR
BY STMT_DETAIL_TYPE
BY STMT_DETAIL_NORM_BAL
BY RECIP_CAT
BY SGL_ACCT
BY FMS_2108_BUS_LINE
ON TABLE HOLD AS WLK3DATA
END
-RUN
-*
-*------------------------------------------
-* If the TABLE_NAME is not passed then    *
-* do not execute the report               *
-*------------------------------------------
-IF '&TABLE_NAME.EVAL' EQ 'FOC_NONE' THEN GOTO ERR;
-*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-*THIS SECTION WILL HANDEL THE "NO DATA" CONDITION.*
-*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-*
-OKTOGO
-*
-*------------------------------------------
-* If the TABLE_NAME is not passed then    *
-* do not execute the report               *
-*------------------------------------------
-IF '&TABLE_NAME.EVAL' EQ 'FOC_NONE' THEN GOTO ERR;
-*-GOTO TIMOTHY
-*
-*------------------------------------------
-* Define fields required in the report    *
-*------------------------------------------

DEFINE FILE WLK3DATA
FY_TXT/A40 = 'Fiscal Year ' | '&SGLFY' | ' Reporting';
PART_TXT/A40 = 'Part ' | '&PART.EVAL' ;
-*
STMT_DETAIL_TYPE1/A5 = DECODE STMT_DETAIL_TYPE (T 'TITLE'
                                                S 'USSGL'
                                                C 'CACL');

END
-RUN
-*------------------------------------------
-* Generate reports                        *
-*------------------------------------------
-*SET COMPOUND=OPEN
TABLE FILE WLK3DATA
PRINT
STMT_TITLE                  AS 'Crosswalk Name'
STMT_DETAIL_LABEL           AS 'Line, No'
STMT_DETAIL_DESCR           AS 'Line Title'
STMT_DETAIL_TYPE1           AS 'Line Type'
STMT_DETAIL_NORM_BAL        AS 'Line Norm Balance'
RECIP_CAT                   AS 'Reciprocal Category '
SGL_ACCT                    AS 'USSGL Account'
&JSTR1.EVAL
FMS_2108_BUS_LINE           AS 'Business Line'
WHERE READLIMIT EQ 10

-*ON TABLE HOLD AS WLK4DATA FORMAT FOCUS
-*END
-*-RUN
-*-EXIT
-*
-*------------------------------------------
-* Based on the format apply style         *
-*------------------------------------------
-IF '&FORMAT.EVAL' EQ 'HTML' THEN GOTO HTMFMT ELSE
-IF '&FORMAT.EVAL' EQ 'PDF'  THEN GOTO PDFFMT ELSE
-IF '&FORMAT.EVAL' EQ 'EXL2K' THEN GOTO EXLFMT ;
-*
-*------------------------------------------
-* EXCEL Formatting                         *
-*------------------------------------------
-EXLFMT
HEADING
"<PART_TXT<FY_TXT"
" "
"&RPT_TITLE_1"
" "
FOOTING
-*
ON TABLE NOTOTAL
-*ON TABLE PCHOLD FORMAT EXL2K 
-*ON TABLE PCHOLD FORMAT PDF &OPEN &NOBREAK
-*ON TABLE HOLD AS HOLD1 FORMAT EXL2K TEMPLATE 'COMPXLS_SINGLE' SHEETNUMBER 1
-*ON TABLE PCHOLD FORMAT EXL2K OPEN SHEETNUM1
ON TABLE PCHOLD FORMAT EXL2K OPEN  
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=9,GRID=ON,
$
-*TYPE=HEADING,WRAP=1,$
TYPE=HEADING,HEADALIGN=BODY,$
-*********
-*Heading*
TYPE=HEADING,LINE=1, ITEM=1,JUSTIFY=LEFT,COLSPAN=12,STYLE=BOLD,$
TYPE=HEADING,LINE=1,OBJECT=FIELD,ITEM=2,JUSTIFY=RIGHT,STYLE=BOLD,$
TYPE=HEADING,LINE=2,ITEM=1,JUSTIFY=LEFT,COLSPAN=9,STYLE=BOLD,$
TYPE=HEADING,LINE=2,ITEM=2, POSITION=9.95,JUSTIFY=RIGHT,STYLE=BOLD,$
TYPE=HEADING,LINE=3,JUSTIFY=CENTER,STYLE=BOLD,COLSPAN=13,$

-************************
-*STYLING FOR THE TITLES*
-************************
TYPE=TITLE,  COLUMN=N1,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N2,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N3,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N4,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N5,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N6,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N7,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N8,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N9,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N10,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N11,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N12,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N13,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N14,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N15,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N16,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N17,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N18,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
-*TYPE=TITLE,  COLUMN=N10,JUSTIFY=CENTER,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
-**********************
-*STYLING FOR THE DATA*
-**********************
-*TYPE=DATA,COLUMN=N1, BORDER-COLOR='SILVER',BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT, $
TYPE=DATA,COLUMN=N1,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT, $
TYPE=DATA,COLUMN=N2,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1.5,WRAP=1.5,$
TYPE=DATA,COLUMN=N3,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT, WIDTH=2,WRAP=2,$
TYPE=DATA,COLUMN=N4,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,$
TYPE=DATA,COLUMN=N5,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1.0,WRAP=1.0,$
TYPE=DATA,COLUMN=N6,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N7,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N8,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N9,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N10, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N11, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N12, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N13, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N14, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N15, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N16, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N17, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N18, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
-*TIME STAMP IN FAR RIGHT CORNER
TYPE=FOOTING,LINE=1,OBJECT=TEXT,ITEM=1,JUSTIFY=RIGHT,position=1.2, $
ENDSTYLE
END
-*-RUN
-*-EXIT
-*------------------------------------------------
-* Generate reports the second (2nd) report      *
-*------------------------------------------------
-*-TIMOTHY
-*-SET &TABLE_NAME1 = &TABLE_NAME || '_C';
-*-TYPE &&&= &TABLE_NAME1
-*-EXIT
-*------------------------------------------
-* Define fields required in the report    *
-*------------------------------------------
DEFINE FILE &TABLE_NAME1
FY_TXT/A40 = 'Fiscal Year ' | '&SGLFY' | ' Reporting';
PART_TXT/A40 = 'Part ' | '&PART.EVAL' ;
-*
-*STMT_DETAIL_TYPE1/A5 = DECODE STMT_DETAIL_TYPE (T 'TITLE'
-*                                                S 'USSGL'
-*                                                C 'CACL');

END
-RUN
-*
-*SET COMPOUND=CLOSE
TABLE FILE &TABLE_NAME1
PRINT
CROSSWALKNAME
CALCLINE
CALCLINETITLE
ASSIGNEDLINE
ASSIGNEDLINETITLE
ASSIGNEDLINESTATEMENT
-*WHERE READLIMIT EQ 10
-*END
-*-RUN
-*-EXIT
-*
-*------------------------------------------
-* Based on the format apply style         *
-*------------------------------------------
-IF '&FORMAT.EVAL' EQ 'HTML' THEN GOTO HTMFMT ELSE
-IF '&FORMAT.EVAL' EQ 'PDF'  THEN GOTO PDFFMT ELSE
-IF '&FORMAT.EVAL' EQ 'EXL2K' THEN GOTO EXLFMT ;
-*-EXIT
-*
-*------------------------------------------
-* EXCEL Formatting                         *
-*------------------------------------------
-EXLFMT
HEADING
"<PART_TXT<FY_TXT"
" "
"&RPT_TITLE_1"
" "
FOOTING
-*
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K CLOSE 
-*ON TABLE PCHOLD FORMAT EXL2K CLOSE SHEETNUM2
-*ON TABLE PCHOLD FORMAT EXL2K TEMPLATE 'COMPXLSH' SHEETNUMBER 2
-*ON TABLE PCHOLD FORMAT EXL2K 
-*ON TABLE PCHOLD FORMAT PDF &OPEN &NOBREAK
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=9,GRID=ON,
$
-*TYPE=HEADING,WRAP=1,$
TYPE=HEADING,HEADALIGN=BODY,$
-*********
-*Heading*
TYPE=HEADING,LINE=1, ITEM=1,JUSTIFY=LEFT,COLSPAN=12,STYLE=BOLD,$
TYPE=HEADING,LINE=1,OBJECT=FIELD,ITEM=2,JUSTIFY=RIGHT,STYLE=BOLD,$
TYPE=HEADING,LINE=2,ITEM=1,JUSTIFY=LEFT,COLSPAN=9,STYLE=BOLD,$
TYPE=HEADING,LINE=2,ITEM=2, POSITION=9.95,JUSTIFY=RIGHT,STYLE=BOLD,$
TYPE=HEADING,LINE=3,JUSTIFY=CENTER,STYLE=BOLD,COLSPAN=13,$

-************************
-*STYLING FOR THE TITLES*
-************************
TYPE=TITLE,  COLUMN=N1,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N2,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N3,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N4,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N5,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N6,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N7,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N8,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N9,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N10,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N11,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N12,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N13,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N14,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N15,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N16,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N17,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N18,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
-*TYPE=TITLE,  COLUMN=N10,JUSTIFY=CENTER,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
-**********************
-*STYLING FOR THE DATA*
-**********************
-*TYPE=DATA,COLUMN=N1, BORDER-COLOR='SILVER',BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT, $
TYPE=DATA,COLUMN=N1,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT, $
TYPE=DATA,COLUMN=N2,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1.5,WRAP=1.5,$
TYPE=DATA,COLUMN=N3,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT, WIDTH=2,WRAP=2,$
TYPE=DATA,COLUMN=N4,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,$
TYPE=DATA,COLUMN=N5,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1.0,WRAP=1.0,$
TYPE=DATA,COLUMN=N6,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N7,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N8,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N9,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N10, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N11, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N12, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N13, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N14, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N15, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N16, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N17, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N18, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
-*TIME STAMP IN FAR RIGHT CORNER
TYPE=FOOTING,LINE=1,OBJECT=TEXT,ITEM=1,JUSTIFY=RIGHT,position=1.2, $
ENDSTYLE
END
-*-RUN
-GOTO RPTEND
-*------------------------------------------
-* Handle empty report                     *
-*------------------------------------------
-NODATA
-*
-*------------------------------------------
-* Get the RELEASE LABEL value             *
-*------------------------------------------
EXEC GTAS_GET_RELEASE_LABEL RELEASE='&RELEASE'
-RUN
-TYPE RELEASE_LABEL = '&&RELEASE_LABEL'
-*
-*------------------------------------------
-* Get the SFL_FY value                    *
-*------------------------------------------
EXEC GTAS_GET_FY RELEASE='&RELEASE', PART='&PART'
-RUN
-TYPE SFL_FY = '&&SGL_FY'
-*-EXIT

-*
-*------------------------------------------
-* Generate report                         *
-*------------------------------------------
TABLE FILE &TABLE_NAME
PRINT
DATA_FLAG NOPRINT
-*
-*------------------------------------------
-* Based on the format apply style         *
-*------------------------------------------
-IF '&FORMAT.EVAL' EQ 'HTML' THEN GOTO HTMFMT ELSE
-IF '&FORMAT.EVAL' EQ 'PDF'  THEN GOTO PDFFMT ELSE
-IF '&FORMAT.EVAL' EQ 'EXL2K' THEN GOTO EXLFMTE ;
-*-EXIT
-*
-*------------------------------------------
-* EXCEL Formatting                         *
-*------------------------------------------
-EXLFMTE
HEADING
"<PART_TXT<FY_TXT"
" "
"&RPT_TITLE_1"
" "
FOOTING
-*
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K 
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=9,GRID=ON,
$
-*TYPE=HEADING,WRAP=1,$
TYPE=HEADING,HEADALIGN=BODY,$
-*********
-*Heading*
TYPE=HEADING,LINE=1, ITEM=1,JUSTIFY=LEFT,COLSPAN=12,STYLE=BOLD,$
TYPE=HEADING,LINE=1,OBJECT=FIELD,ITEM=2,JUSTIFY=RIGHT,STYLE=BOLD,$
TYPE=HEADING,LINE=2,ITEM=1,JUSTIFY=LEFT,COLSPAN=9,STYLE=BOLD,$
TYPE=HEADING,LINE=2,ITEM=2, POSITION=9.95,JUSTIFY=RIGHT,STYLE=BOLD,$
TYPE=HEADING,LINE=3,JUSTIFY=CENTER,STYLE=BOLD,COLSPAN=13,$

-************************
-*STYLING FOR THE TITLES*
-************************
TYPE=TITLE,  COLUMN=N1,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N2,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N3,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N4,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N5,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N6,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N7,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N8,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N9,JUSTIFY=LEFT  ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N10,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N11,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N12,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N13,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N14,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N15,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N16,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N17,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
TYPE=TITLE,  COLUMN=N18,JUSTIFY=LEFT ,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
-*TYPE=TITLE,  COLUMN=N10,JUSTIFY=CENTER,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-RIGHT=LIGHT,BACKCOLOR='SILVER',$
-**********************
-*STYLING FOR THE DATA*
-**********************
-*TYPE=DATA,COLUMN=N1, BORDER-COLOR='SILVER',BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT, $
TYPE=DATA,COLUMN=N1,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT, $
TYPE=DATA,COLUMN=N2,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1.5,WRAP=1.5,$
TYPE=DATA,COLUMN=N3,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT, WIDTH=2,WRAP=2,$
TYPE=DATA,COLUMN=N4,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,$
TYPE=DATA,COLUMN=N5,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1.0,WRAP=1.0,$
TYPE=DATA,COLUMN=N6,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N7,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N8,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N9,  BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N10, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N11, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N12, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N13, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N14, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N15, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N16, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N17, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
TYPE=DATA,COLUMN=N18, BORDER-BOTTOM=LIGHT,BORDER-TOP=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,JUSTIFY=LEFT,WIDTH=1,WRAP=1,$
-*TIME STAMP IN FAR RIGHT CORNER
TYPE=FOOTING,LINE=1,OBJECT=TEXT,ITEM=1,JUSTIFY=RIGHT,position=1.2, $
ENDSTYLE
END
-RUN
-*
-*------------------------------------------
-* End of the module                       *
-*------------------------------------------
-RPTEND

-*-RPTEND

Posts: 38 | Location: Atlanta | Registered: June 14, 2005

Report This Post

Ignored post by tlbrydie posted

Silver Member

posted

It appears that I can get everything to work if I take the styling off. Thanks for the help guys and gals. Consider this on Solved...I'll work it out from here.

Really....thanks allot!

Timothy

Posts: 38 | Location: Atlanta | Registered: June 14, 2005

Report This Post

Ignored post by tlbrydie posted

Powered by Social Strata

Please Wait. Your request is being processed...

Read-Only Topic

Focal Point Forums

Hop To Forum Categories

WebFOCUS/FOCUS Forum on Focal Point

[SOLVED] excel compound report/w excel 2003

Focal Point | Privacy Statement | Terms of Service

Copyright © 1996-2020 Information Builders

	View $GS_USERNAME's Public Profile
	Add $GS_USERNAME to my Ignore ListRemove $GS_USERNAME from my Ignore List
	View Recent Posts by $GS_USERNAME
	Notify me of New Posts by $GS_USERNAME

New Since your Last Visit