I am trying to build a drillable income statement in FML with the ‘For’ field as drillable column, that drills down to trail balance report. I noticed the following
1. When I drill down on the ‘For’ column, it picks the title of the tag as parameter instead of the value or range of values in the tag, resulting in zero resutls returned in the child report.
2. If I remove the title from the tag line, then it does drill down but only passes the first value in the list of values or range of values assinged to the tag line.
Is this how its suppose to work? If so, then looks like it will not work for what I am trying to do i.e. show detail lines for all the list of accounts that tie to a particular income statement line.
I am thinking of generating an intermediate report that will have only the visible lines on the income statement and then assing each line a reference number, then I subsequently assing that reference number to each of the trial balance lines that I want to show on the drill down for any particular income statement line. Is this the best option to go with or can someone recommend a better approach. Thanks!

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

Texgator,

We had Walter from the helpdesk work with us to get this going along with considerable input from Harry. I think the heirarchy is a little clunky, but they got it working for us.

I am posting all of my code so you can follow along. Pay attention to the compute line:

COMPUTE FMLLIST/A50 = FMLLIST('A4096V'); NOPRINT

We use the drill down to jump to another report for transaction detail, but the concept should be the same for the detail accounts.

I am amazed that the financial community is not not really represented enough on the site. We saved so much money by passing on consolidation software and using WF instead. We are not programmers and we can only understand the GUI application so we may not be able to expand on any additional questions. Anyway, here's the code:

-* File VIEW_PLMQYV.fex
SET PRINTPLUS = OFF
SET CNOTATION = EXPLICIT
SET NODATA = 0
SET FOCEXURL=http://wasprod1:12345/ibi_apps/WFServlet
DEFINE FILE NBGLVIEW1
PERIOD/I4=.
FY/YY=&FY;
CFY/YY=FY;
LFY/YY=FY-1;
MTD/D12.2=IF PERIOD EQ 1 THEN NET01 ELSE IF PERIOD EQ 2 THEN NET02 ELSE IF PERIOD EQ 3 THEN NET03 ELSE IF PERIOD EQ 4 THEN NET04 ELSE IF PERIOD EQ 5 THEN NET05 ELSE IF PERIOD EQ 6 THEN NET06 ELSE IF PERIOD EQ 7 THEN NET07 ELSE IF PERIOD EQ 8 THEN NET08 ELSE IF PERIOD EQ 9 THEN NET09 ELSE IF PERIOD EQ 10 THEN NET10 ELSE IF PERIOD EQ 11 THEN NET11 ELSE IF PERIOD EQ 12 THEN NET12 ELSE 0;
QTD/D12.2=IF PERIOD EQ 1 THEN NET01 ELSE IF PERIOD EQ 2 THEN NET01 + NET02 ELSE IF PERIOD EQ 3 THEN NET01 + NET02 + NET03 ELSE IF PERIOD EQ 4 THEN NET04 ELSE IF PERIOD EQ 5 THEN NET04 + NET05 ELSE IF PERIOD EQ 6 THEN NET04 + NET05 + NET06 ELSE IF PERIOD EQ 7 THEN NET07 ELSE IF PERIOD EQ 8 THEN NET07 + NET08 ELSE IF PERIOD EQ 9 THEN NET07 + NET08 + NET09 ELSE IF PERIOD EQ 10 THEN NET10 ELSE IF PERIOD EQ 11 THEN NET10 + NET11 ELSE IF PERIOD EQ 12 THEN NET10 + NET11 + NET12 ELSE 0;
YTD/D12.2=IF PERIOD EQ 1 THEN NET01 ELSE IF PERIOD EQ 2 THEN NET01 + NET02 ELSE IF PERIOD EQ 3 THEN NET01 + NET02 + NET03 ELSE IF PERIOD EQ 4 THEN NET01 + NET02 + NET03 + NET04 ELSE IF PERIOD EQ 5 THEN NET01 + NET02 + NET03 + NET04 + NET05 ELSE IF PERIOD EQ 6 THEN NET01 + NET02 + NET03 + NET04 + NET05 + NET06 ELSE IF PERIOD EQ 7 THEN NET01 + NET02 + NET03 + NET04 + NET05 + NET06 + NET07 ELSE IF PERIOD EQ 8 THEN NET01 + NET02 + NET03 + NET04 + NET05 + NET06 + NET07 + NET08 ELSE IF PERIOD EQ 9 THEN NET01 + NET02 + NET03 + NET04 + NET05 + NET06 + NET07 + NET08 + NET09 ELSE IF PERIOD EQ 10 THEN NET01 + NET02 + NET03 + NET04 + NET05 + NET06 + NET07 + NET08 + NET09 + NET10 ELSE IF PERIOD EQ 11 THEN NET01 + NET02 + NET03 + NET04 + NET05 + NET06 + NET07 + NET08 + NET09 + NET10 + NET11 ELSE IF PERIOD EQ 12 THEN NET01 + NET02 + NET03 + NET04 + NET05 + NET06 + NET07 + NET08 + NET09 + NET10 + NET11 + NET12 ELSE 0;
CMTD/D12C=IF GAM_FISCAL_YEAR EQ CFY THEN MTD ELSE 0;
LMTD/D12C=IF GAM_FISCAL_YEAR EQ LFY THEN MTD ELSE 0;
CQTD/D12C=IF GAM_FISCAL_YEAR EQ CFY THEN QTD ELSE 0;
LQTD/D12C=IF GAM_FISCAL_YEAR EQ LFY THEN QTD ELSE 0;
CYTD/D12C=IF GAM_FISCAL_YEAR EQ CFY THEN YTD ELSE 0;
LYTD/D12C=IF GAM_FISCAL_YEAR EQ LFY THEN YTD ELSE 0;
CMTDSALES/D12.2=IF (GAM_ACCOUNT GE 40000 AND GAM_ACCOUNT LE 42999) THEN CMTD ELSE 0;
LMTDSALES/D12.2=IF (GAM_ACCOUNT GE 40000 AND GAM_ACCOUNT LE 42999) THEN LMTD ELSE 0;
CQTDSALES/D12.2=IF (GAM_ACCOUNT GE 40000 AND GAM_ACCOUNT LE 42999) THEN CQTD ELSE 0;
LQTDSALES/D12.2=IF (GAM_ACCOUNT GE 40000 AND GAM_ACCOUNT LE 42999) THEN LQTD ELSE 0;
CYTDSALES/D12.2=IF (GAM_ACCOUNT GE 40000 AND GAM_ACCOUNT LE 42999) THEN CYTD ELSE 0;
LYTDSALES/D12.2=IF (GAM_ACCOUNT GE 40000 AND GAM_ACCOUNT LE 42999) THEN LYTD ELSE 0;
MPERIOD/A20=DECODE PERIOD( 1 'MONTH ENDED 10/31' 2 'MONTH ENDED 11/30' 3 'MONTH ENDED 12/31' 4 'MONTH ENDED 1/31' 5 'MONTH ENDED 2/28' 6 'MONTH ENDED 3/31' 7 'MONTH ENDED 4/30' 8 'MONTH ENDED 5/31' 9 'MONTH ENDED 6/30' 10 'MONTH ENDED 7/31' 11 'MONTH ENDED 8/31' 12 'MONTH ENDED 9/30' );
QPERIOD/A20=DECODE PERIOD( 1 '1 MONTH ENDED 10/31' 2 '2 MONTHS ENDED 11/30' 3 '3 MONTHS ENDED 12/31' 4 '1 MONTH ENDED 1/31' 5 '2 MONTHS ENDED 2/28' 6 '3 MONTHS ENDED 3/31' 7 '1 MONTH ENDED 4/30' 8 '2 MONTHS ENDED 5/31' 9 '3 MONTHS ENDED 6/30' 10 '1 MONTH ENDED 7/31' 11 '2 MONTHS ENDED 8/31' 12 '3 MONTHS ENDED 9/30' );
YPERIOD/A20=DECODE PERIOD( 1 '1 MONTH ENDED 10/31' 2 '2 MONTHS ENDED 11/30' 3 '3 MONTHS ENDED 12/31' 4 '4 MONTHS ENDED 1/31' 5 '5 MONTHS ENDED 2/28' 6 '6 MONTHS ENDED 3/31' 7 '7 MONTHS ENDED 4/30' 8 '8 MONTHS ENDED 5/31' 9 '9 MONTHS ENDED 6/30' 10 '10 MONTHS ENDED 7/31' 11 '11 MONTHS ENDED 8/31' 12 '12 MONTHS ENDED 9/30' );
AMVDES/A30=DECODE AMV_MX_VALUE( 'ESTER C' 'ESTER C BRAND' 'ESTER C RM' 'ESTER C RAW MATERIAL' HB 'H and B RETAIL' LENAT 'LE NATURISTE' 'LENAT DR' 'LE NATURISTE DIRECT REPSONSE' PLCMFG 'PL CONTRACT MFG BAYER' 'RETAIL ' 'VITAMIN WORLD' 'REXALL BRAND' 'PRIVATE LABEL CONTROL REXALL' 'SOLGAR' 'SOLGAR US' 'INTL REG CAN' 'NBTY CANADA' 'VW LTD' 'HB DIRECT');
END
TABLE FILE NBGLVIEW1
SUM
'NBGLVIEW1.NBGLVIEW1.CMTD/D12CB' AS 'Current,MTD'
'NBGLVIEW1.NBGLVIEW1.CMTDSALES' WITHIN AMV_MX_VALUE NOPRINT
COMPUTE PERCMTD/D7.2B% = CMTD / C2 * 100; AS '%Sales'
'NBGLVIEW1.NBGLVIEW1.LMTD/D10CB' AS 'Prior,MTD'
'NBGLVIEW1.NBGLVIEW1.LMTDSALES' WITHIN AMV_MX_VALUE NOPRINT
COMPUTE PERLMTD/D7.2CB% = LMTD / C5 * 100; AS '%Sales'
COMPUTE MVAR/D10CB = CMTD - LMTD; AS 'Variance'
COMPUTE MVARPER/D7.2B% = MVAR / LMTD * 100; AS '%Var'
'NBGLVIEW1.NBGLVIEW1.CYTD/D13B' AS 'Current,YTD'
'NBGLVIEW1.NBGLVIEW1.CYTDSALES' WITHIN AMV_MX_VALUE NOPRINT
COMPUTE PERCYTD/D7.2B% = CYTD / C10 * 100; AS '%Sales'
'NBGLVIEW1.NBGLVIEW1.LYTD/D13B' AS 'Prior,YTD'
'NBGLVIEW1.NBGLVIEW1.LYTDSALES' WITHIN AMV_MX_VALUE NOPRINT
COMPUTE PERLYTD/D7.2B% = LYTD / C13 * 100; AS '%Sales'
COMPUTE YVAR/D10B = CYTD - LYTD; AS 'Variance'
COMPUTE YVARPER/D7.2B% = YVAR / LYTD * 100; AS '%Var'
COMPUTE FMLLIST/A50 = FMLLIST('A4096V'); NOPRINT
BY 'NBGLVIEW1.NBGLVIEW1.AMV_MX_VALUE' NOPRINT
FOR
'NBGLVIEW1.NBGLVIEW1.GAC_MX_VALUE'
'SALES' AS 'SALES' LABEL R1 WHEN EXISTS OVER
'COGS' AS 'COGS' LABEL R2 WHEN EXISTS OVER
BAR AS '-' OVER
RECAP R4(1)/D12C=(R1-R2);
R4(3)=R4(1) / R1(2) * 100;
R4(4)/D12C=(R1-R2);
R4(6)=R4(4) / R1(5) * 100;
R4(7)/D12CB=(R1-R2);
R4(8)=R4(7) / R4(4) * 100;
R4(9)/D12C=(R1-R2);
R4(11)=R4(9) / R1(10) * 100;
R4(12)/D12C=(R1-R2);
R4(14)=R4(12) / R1(12) * 100;
R4(15)/D12CB=(R1-R2);
R4(16)=R4(15) / R4(12) * 100;
AS 'GROSS PROFIT' OVER
" " LABEL R5 OVER
"<2 ADVERTISING, PROMOS, CATALOGS" LABEL R6 OVER
'ADVERTISING' AS 'ADVERTISING, PROMOS & MEDIA' LABEL R7 WHEN EXISTS OVER
'CATALOG' AS 'CATALOG PRINTING AND MAILING' LABEL R8 WHEN EXISTS OVER
BAR AS '-' OVER
RECAP R10(1)=R7+R8;
R10(3)=R10(1) / R1(2) * 100;
R10(4)=R7+R8;
R10(6)=R10(4) / R1(5) * 100;
R10(7)/D12CB=R7+R8;
R10(8)=R10(7) / R10(4) * 100;
R10(9)=R7+R8;
R10(11)=R10(9) / R1(10) * 100;
R10(12)=R7+R8;
R10(14)=R10(12) / R1(12) * 100;
R10(15)=R7+R8;
R10(16)=R10(15) / R10(12) * 100;
AS 'TOTAL ADVERTISING PROMO EXP' OVER
" " LABEL R11 OVER
"<2 SELLING, GENERAL & ADMIN EXP" LABEL R12 OVER
'DIRECT LABOR' OR 'SALARIES' AS 'SALARIES & WAGES' LABEL R13 WHEN EXISTS OVER
'FRINGES' AS 'PAYROLL FRINGE BENEFITS' LABEL R14 WHEN EXISTS OVER
'SUPPLIES' AS 'STATIONERY & SUPPLIES' LABEL R15 WHEN EXISTS OVER
'BUILDING' AS 'BUILDING' LABEL R16 WHEN EXISTS OVER
'REPAIRS' AS 'REPAIRS & MAINTENANCE' LABEL R17 WHEN EXISTS OVER
'POSTAGE' AS 'POSTAGE' LABEL R18 WHEN EXISTS OVER
'TELEPHONE' AS 'TELEPHONE' LABEL R19 WHEN EXISTS OVER
'TE' AS 'TRAVEL, AUTO & ENTERTAINMENT' LABEL R20 WHEN EXISTS OVER
'SERVICES' AS 'OUTSIDE SERVICES' LABEL R21 WHEN EXISTS OVER
'PROF FEES' AS 'PROFESSIONAL & LEGAL' LABEL R22 WHEN EXISTS OVER
'FREIGHT' AS 'FREIGHT' LABEL R23 WHEN EXISTS OVER
'TAXES' AS 'TAXES- REAL ESTATE/LOCAL' LABEL R24 WHEN EXISTS OVER
'OTHER' AS 'OTHER' LABEL R25 WHEN EXISTS OVER
'COMMISSIONS' AS 'COMMISSIONS TO BROKERS' LABEL R26 WHEN EXISTS OVER
'INSURANCE' AS 'INSURANCE' LABEL R27 WHEN EXISTS OVER
'DEPRECIATION' AS 'DEPRECIATION / AMORT OF PPE' LABEL R28 WHEN EXISTS OVER
'AMORTIZATION' AS 'AMORTIZATION OF INTANGIBLES' LABEL R29 WHEN EXISTS OVER
'SGA ALLOCS' OR 'MFG ALLOCS' AS 'SGA ALLOCATIONS' LABEL R30 WHEN EXISTS OVER
'CORPOPALL' AS 'CORP OPERATING ALLOCS' LABEL R31 OVER
BAR AS '-' OVER
RECAP R33(1)=R13+R14+R15+R16+R17+R18+R19+R20+R21+R22+R23+R24+R25+R26+R27+R28+R29+R30+R31;
R33(3)=R33(1) / R1(2) * 100;
R33(4)=R13+R14+R15+R16+R17+R18+R19+R20+R21+R22+R23+R24+R25+R26+R27+R28+R29+R30+R31;
R33(6)=R33(4) / R1(5) * 100;
R33(7)=R13+R14+R15+R16+R17+R18+R19+R20+R21+R22+R23+R24+R25+R26+R27+R28+R29+R30+R31;
R33(8)/D12.2B=R33(7) / R33(4) * 100;
R33(9)=R13+R14+R15+R16+R17+R18+R19+R20+R21+R22+R23+R24+R25+R26+R27+R28+R29+R30+R31;
R33(11)=R33(9) / R1(10) * 100;
R33(12)=R13+R14+R15+R16+R17+R18+R19+R20+R21+R22+R23+R24+R25+R26+R27+R28+R29+R30+R31;
R33(14)=R33(12) / R1(12) * 100;
R33(15)=R13+R14+R15+R16+R17+R18+R19+R20+R21+R22+R23+R24+R25+R26+R27+R28+R29+R30+R31;
R33(16)/D12.2B=R33(15) / R33(12) * 100;
AS 'TOTAL SELLING, GEN. & ADMIN.' OVER
" " LABEL R34 OVER
RECAP R35(1)=R10+R33;
R35(3)=R35(1) / R1(2) * 100;
R35(4)=R10+R33;
R35(6)=R35(4) / R1(5) * 100;
R35(7)=R10+R33;
R35(8)=R35(7) / R35(4) * 100;
R35(9)=R10+R33;
R35(11)=R35(9) / R1(10) * 100;
R35(12)=R10+R33;
R35(14)=R35(12) / R1(12) * 100;
R35(15)=R10+R33;
R35(16)=R35(15) / R35(12) * 100;
AS 'TOTAL EXPENSES' OVER
BAR AS '-' OVER
" " LABEL R37 OVER
RECAP R38(1)=R4 - R35;
R38(3)=R38(1) / R1(2) * 100;
R38(4)=R4 - R35;
R38(6)=R38(4) / R1(5) * 100;
R38(7)=R4 - R35;
R38(8)=R38(7) / R38(4) * 100;
R38(9)=R4 - R35;
R38(11)=R38(9) / R1(10) * 100;
R38(12)=R4 - R35;
R38(14)=R38(12) / R1(12) * 100;
R38(15)=R4 - R35;
R38(16)=R38(15) / R38(12) * 100;
AS 'OPERATING INCOME (LOSS)'

ON NBGLVIEW1.NBGLVIEW1.AMV_MX_VALUE PAGE-BREAK
HEADING
"Date: &DATEtrMDYY CONSOLIDATED STATEMENTS OF INCOME<+0>NBTY, INC. AND SUBSIDIARIES<+0> "
"Time: &TOD<+0>STATEMENT OF PROFIT (LOSS)<+0> "
"Report: &FOCFEXNAME<+0> <+0> "
" "Brand / Division <+0> <+0> <+0> "
"ON TABLE SUBFOOT
""
WHERE ( GAC_MATRIX_CAT EQ 'SECSUM' ) AND ( AMV_MATRIX_CAT EQ 'DIVISIONNBTY' ) AND ( GLS_CURRENCY_CODE EQ 'USD' ) AND ( AMV_MX_VALUE NE 'MFG' );
WHERE AMV_MX_VALUE EQ &AMV_MX_VALUE.(OR(FIND BRAND IN brand)).Brand / Division.;
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT ,
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.125000,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=7,
LEFTGAP=0.055556,
$
TYPE=DATA,
COLUMN=N2,
SIZE=7,
$
TYPE=DATA,
COLUMN=N3,
SIZE=7,
FOCEXEC=transactions_brand_drilldown( \
AMV_MX_VALUE=NBGLVIEW1.NBGLVIEW1.AMV_MX_VALUE \
GAC_MX_VALUE=FMLLIST \
FY='&FY' \
GLT_ACCT_PERIOD='&PERIOD' \
),
$
TYPE=DATA,
COLUMN=N6,
SIZE=7,
FOCEXEC=transactions_brand_drilldown( \
AMV_MX_VALUE=NBGLVIEW1.NBGLVIEW1.AMV_MX_VALUE \
GAC_MX_VALUE=FMLLIST \
FY= \
GLT_ACCT_PERIOD='&PERIOD' \
),
$
TYPE=DATA,
COLUMN=N13,
SIZE=7,
$
TYPE=DATA,
COLUMN=N16,
SIZE=7,
$
TYPE=DATA,
COLUMN=N17,
SIZE=7,
$
TYPE=DATA,
COLUMN=N18,
SIZE=7,
$
TYPE=DATA,
COLUMN=N10,
BORDER-RIGHT=MEDIUM,
SIZE=7,
$
TYPE=DATA,
COLUMN=N9,
SIZE=7,
$
TYPE=DATA,
COLUMN=N8,
SIZE=7,
$
TYPE=DATA,
COLUMN=N1,
SIZE=7,
$
TYPE=DATA,
COLUMN=N14,
SIZE=7,
$
TYPE=DATA,
COLUMN=N11,
SIZE=7,
$
TYPE=DATA,
COLUMN=N5,
SIZE=7,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N2,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N3,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N6,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N13,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N16,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N17,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N18,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N10,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N9,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N8,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N1,
SIZE=5,
$
TYPE=TITLE,
COLUMN=N14,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N11,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N5,
SIZE=7,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=4.250,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
SIZE=7,
WIDTH=3.625,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=3,
SIZE=6,
JUSTIFY=RIGHT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=3.625,
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=2,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=3,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=4.250,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=2,
SIZE=7,
WIDTH=3.625,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=3,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=4,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=2,
OBJECT=FIELD,
ITEM=1,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=3.625,
$
TYPE=HEADING,
LINE=2,
OBJECT=FIELD,
ITEM=2,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=2,
OBJECT=FIELD,
ITEM=3,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=1.375,
$
TYPE=HEADING,
LINE=2,
OBJECT=FIELD,
ITEM=4,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=HEADING,
LINE=2,
OBJECT=FIELD,
ITEM=5,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=3.125,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=2,
SIZE=6,
WIDTH=3.625,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=3,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=3,
OBJECT=FIELD,
ITEM=1,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=3.000,
$
TYPE=HEADING,
LINE=3,
OBJECT=FIELD,
ITEM=2,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=3,
OBJECT=FIELD,
ITEM=3,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=1.375,
$
TYPE=HEADING,
LINE=3,
OBJECT=FIELD,
ITEM=4,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=HEADING,
LINE=3,
OBJECT=FIELD,
ITEM=5,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=4,
OBJECT=TEXT,
ITEM=1,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=3.625,
$
TYPE=HEADING,
LINE=4,
OBJECT=TEXT,
ITEM=2,
SIZE=6,
WIDTH=3.625,
$
TYPE=HEADING,
LINE=4,
OBJECT=TEXT,
ITEM=3,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=4,
OBJECT=FIELD,
ITEM=1,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=3.125,
$
TYPE=HEADING,
LINE=4,
OBJECT=FIELD,
ITEM=2,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=4,
OBJECT=FIELD,
ITEM=3,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=1.125,
$
TYPE=HEADING,
LINE=4,
OBJECT=FIELD,
ITEM=4,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=HEADING,
LINE=4,
OBJECT=FIELD,
ITEM=5,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=1,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.125,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=2,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=2.750,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.500,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.625,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=5,
JUSTIFY=LEFT,
WIDTH=4.000,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=6,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=1,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.500,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=2,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=3,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=1.375,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=4,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=5,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=1,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.125,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=2,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=2.750,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.500,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.625,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=5,
JUSTIFY=LEFT,
WIDTH=4.000,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=6,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=7,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=6,
OBJECT=FIELD,
ITEM=1,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=HEADING,
LINE=6,
OBJECT=FIELD,
ITEM=2,
SIZE=7,
POSITION='N3',
JUSTIFY=RIGHT,
WIDTH=.875,
$
TYPE=HEADING,
LINE=6,
OBJECT=FIELD,
ITEM=3,
SIZE=7,
POSITION='N6',
JUSTIFY=RIGHT,
WIDTH=.750,
$
TYPE=HEADING,
LINE=6,
OBJECT=FIELD,
ITEM=4,
SIZE=7,
POSITION='N11',
JUSTIFY=RIGHT,
WIDTH=.875,
$
TYPE=HEADING,
LINE=6,
OBJECT=FIELD,
ITEM=5,
SIZE=7,
POSITION='N14',
JUSTIFY=RIGHT,
WIDTH=.875,
$
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,
BORDER-TOP=OFF,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
BORDER-TOP-STYLE=DASHED,
BORDER-BOTTOM-STYLE=DASHED,
BORDER-LEFT-STYLE=DASHED,
BORDER-RIGHT-STYLE=DASHED,
SIZE=9,
$
TYPE=ACROSSTITLE,
BORDER-BOTTOM=LIGHT,
BORDER-BOTTOM-STYLE=DASHED,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
TYPE=FREETEXT,
SIZE=7,
$
ENDSTYLE
END

Dan McDonald
Version : 7.7.01
Platform:WindowsOutput : Excel, PDF, HTML

This link includes help for functions FMLINFO, FMLLIST, FMLFOR, and FMLCAP.

Numeric Functions

Thanks Dan for pointing me to FMLINFO and FMLLIST functions. It appears that they will work for tag lines that use a list of accounts or ranges but not for calculated lines. In my case, I may need to produce tag lines that are not visible but then use them in Recap to print the Recap lines that are visible but it appears that the FML functions cannot retrieve the list of accounts that are involved in a Recap line or can they?
I am working on doing some manipulations on the database side to make these files connected so I can achive the drill down. Thanks again for your input and for posting the code. I am new to this forum and finding it very helpful.

If you use the FMLLIST function as Dan had mentioned, you should get 'VAL' OR 'VAL' OR ....
or whatever is in your tag.