Counting Records

Can you give us an example of how you are trying to present this count? In a SUBFOOT? In the FOOTING or HEADING? As a rolling total column? This will help us give you better assistance.

Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011

Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003

Ignored post by mgrackin posted

Show Post

sludge

Member

posted

Hide Post

The report is broken into segments. I'm trying to add a count in the subfooter and footer of the report to count the number of records in each given segment, then a final grand total.

Posts: 9 | Registered: December 06, 2005

Ignored post by sludge posted

Show Post

Leah

Virtuoso

posted

Hide Post

This is one method you can use:

SET STYLEMODE = FIXED
TABLE FILE CAR
COUNT MODEL NOPRINT
BY COUNTRY
PRINT MODEL SEATS
BY COUNTRY
ON COUNTRY RECAP
CARCOUNT/I5 = C1;
ON COUNTRY SUBFOOT
" "
"COUNT BY COUNTRY IS ON TABLE SUMMARIZE AND SUBFOOT
" "
"TOTAL COUNT IS ON TABLE NOTOTAL
END

Leah

Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004

Ignored post by Leah posted

Show Post

Leah

Virtuoso

posted

Hide Post

"COUNT BY COUNTRY IS ?CARCOUNT"
ON TABLE SUMMARIZE AND SUBFOOT
" "
"TOTAL COUNT IS ?C1"
ON TABLE NOTOTAL
END

Addendum the system doesn't like the less than spot marker. Replace the '?' with the less than symbol '<'

Leah

Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004

Ignored post by Leah posted

Show Post

Platinum Member

posted

Hide Post

Try this:

DEFINE FILE CAR
CARCNT/I4 WITH CAR =1;
END
TABLE FILE CAR
PRINT CAR CARCNT NOPRINT
BY COUNTRY UNDER-LINE
ON COUNTRY SUBFOOT
"TOTAL RECORDS FOr THIS CAR < ST.CARCNT < /1"

ON TABLE SUBFOOT

"TOTAL RECORDS ON REPORT < TOT.CARCNT"

IF COUNTRY EQ ENGLAND OR ITALY
END

COUNTRY CAR
------- ---
ENGLAND JAGUAR
JENSEN
TRIUMPH
TOTAL RECORDS FOR THIS CAR 3

----------------------------
ITALY ALFA ROMEO
MASERATI
TOTAL RECORDS FOR THIS CAR 2

----------------------------
TOTAL RECORDS ON REPORT 5

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

FOCUS 7.6 MVS PDF,HTML,EXCEL

Posts: 115 | Location: Chicago, IL | Registered: May 28, 2004

Ignored post by ET posted

Show Post

Kerry

Expert

posted

Hide Post

Hi sludge,

Has this issue been resolved? Did other users' suggestions help you?

I ran some search on Focal Point and came across the following old topics which may be of interest as well:

COUNT NO. OF RECORDS

row count

Hope this helps.