[SOLVED] NUMBER OF RECORDS IN TABLE=

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,

Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF

Posts: 204 | Registered: March 31, 2008

David Briars

Master

posted

Hide Post

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.

Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster

Posts: 822 | Registered: April 23, 2003

Ignored post by David Briars posted

Show Post

Rick Man

Platinum Member

posted

Hide Post

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.

Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF

Posts: 204 | Registered: March 31, 2008

Ignored post by Rick Man posted

Show Post

Prarie

Virtuoso

posted

Hide Post

&RECORDS ?

Posts: 1903 | Location: San Antonio | Registered: February 28, 2005

Ignored post by Prarie posted

Show Post

David Briars

Master

posted

Hide Post

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: