After a search on the above and wading through most of the 14 pages returned I can't find an answer to the question:

Can I capture the number returned in the message and use it in a report, WITHOUT running another report to count them?

I'm doing the following and would like to create an audit report as the last step. there are 4 files created in the fex.

ON TABLE HOLD AS STUDENT_ACCOUNT FORMAT DFIX DELIMITER ',' HEADER NO

This message has been edited. Last edited by: Rick Man,

The following code..

APP PREPENDPATH IBISAMP
-*
TABLE FILE GGSALES
SUM ST BY ST
ON TABLE HOLD AS HOLD1
END
-RUN
-SET &WORK1 = &LINES;
TABLE FILE GGPRODS
PRINT *
ON TABLE HOLD AS HOLD2
END
-RUN
-SET &WORK2 = &LINES;
-SET &TOTLINES = &WORK1 + &WORK2;
TABLE FILE GGSALES
"TOTAL LINES = &TOTLINES"
PRINT ST AS ''
IF ST EQ XX
ON TABLE SET PAGE OFF
ON TABLE SET EMPTYREPORT ON
END
-EXIT  

..Yields..:

TOTAL LINES = 21

..in the browser.

But lines and records can be different. For Example: 0 NUMBER OF RECORDS IN TABLE= 14586 LINES= 1

But maybe in my case they are. I'm not doing a SUM.

&RECORDS ?

To obtain and deal with the number of records retrieved, instead of the number of output lines, use the WF statistical variable &RECORDS, in place of &LINES:

APP PREPENDPATH IBISAMP
-*
TABLE FILE GGSALES
SUM ST BY ST
ON TABLE HOLD AS HOLD1
END
-RUN
-SET &WORK1 = &RECORDS;
TABLE FILE GGPRODS
PRINT *
ON TABLE HOLD AS HOLD2
END
-RUN
-SET &WORK2 = &RECORDS;
-SET &TOTRECS = &WORK1 + &WORK2;
TABLE FILE GGSALES
"TOTAL RECORDS = &TOTRECS"
PRINT ST AS ''
IF ST EQ XX
ON TABLE SET PAGE OFF
ON TABLE SET EMPTYREPORT ON
END
-EXIT

Yields:

TOTAL RECORDS = 4327

DUH. I did a -? & and the &RECORDS was 1. I knew that wasn't right. I must have had to do a -RUN in there.
Thanks