Does anyone have an easy way of counting rows in a report or a report section?
I'd appreciate the help.
Thanks.

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.

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.

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

"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 '<'

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,

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.

Cheers,

Kerry

Thanks for all the suggestions. I will let you know the result when I am finally able to get back to it.