What I want to do is that I want to pass &RECORDS or &LINES to the HTML Composer after run the report.
Although I bind the fex file with my HTML composer, I can't find the &RECORDS or &LINES in parameter tag.
So, how can I retrieve like these values from the js of HTML composer ?
WebFOCUS 8.1.05M Windows, Excel , CSV Outputs
January 25, 2018, 08:36 AM
Chaudhary
you can try like this and bind your HTML control with LINECOUNT
TABLE FILE CAR
BY CAR.COMP.CAR
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS LINECNT
END
-SET &LIN = &LINES;
TABLE FILE LINECNT
SUM COMPUTE LINECOUNT/D20 = &LIN;
CAR NOPRINT
ON TABLE PCHOLD AS LINECNT
END
you can try this also if you don't have any where clause in your table file request ,
DEFINE FILE CAR
CNT/D20 = CNT+1;
END
TABLE FILE CAR
SUM
MAX.CNT AS LINECOUNT
CAR.COMP.CAR NOPRINT
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XML
END