Produced below are couple of lines from an income statement that I created using 'FOR'. I want to pass the line no (110, 116) to the child report but when I do it, the descriptions (Gross Sales, etc.) gets passed and not the line no because of 'AS'. Is there a way that I show the descriptions on the income statments but when the description is clicked, I pass the actual line no. to the child report.

FOR
'INC_STH.SEG01.ISLINO'
' 110' AS 'Gross Sales' LABEL R1 OVER
' 116' AS 'Less Discounts and Allowances' LABEL R2 OVER


Here is the drill down. I have tried qualified line no. field instead of N1 but it gets same results.

TYPE=DATA,
COLUMN=N1,
TARGET='_blank',
FOCEXEC=app/trialb_bymainlocdept( \
lino= N1 \
),
$

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

Will any of the FML functions (FMLINFO, etc.) help?
Numeric Functions

This might work (you had me stumped for a bit): Add

INC_STH.SEG01.ISLINO NOPRINT

and pass that field in the drilldown:

lino= INC_STH.SEG01.ISLINO

An example:

-SET &ECHO=ALL;

TABLE FILE CAR
SUM
SALES               AS ''
BODYTYPE            NOPRINT

FOR BODYTYPE
SEDAN               AS 'Sedan'
OVER
ROADSTER            AS 'Roadster'

ON TABLE SET STYLE *

TYPE=DATA,
COLUMN=N1,
TARGET='_blank',
FOCEXEC=testfml2( \
BODYTYPE=BODYTYPE \
),$

ENDSTYLE
END

Thanks guys. I was able to use FMLFOR and then pass LINENO to the child report and it worked.
COMPUTE LINENO/P8 = FMLFOR ('P8');

Thanks.