Hi,
I have a report that has several groups of rows. I want to number each row in a group starting from 1. For example, if group 1 has 10 rows, they will be numbered from 1 to 10, then if group 2 has 15 rows it will be numbered from 1 to 15. How do I do that in Webfocus?
Thanks
Abu

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

Create a counter field.

COMPUTE RANK1/I9 = IF (sortfield1 NE LAST sortfield1) THEN 1 ELSE RANK1 + 1;

Thanks Mary, it works perfectly as I wanted.

Well put Mary,

Try this (SEQUENCE):

TABLE FILE CAR
PRINT MODEL
COMPUTE RANK1/I9 = IF (COUNTRY NE LAST COUNTRY) THEN 1 ELSE RANK1 + 1;
BY COUNTRY
BY CAR
ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=RANK1, SEQUENCE=1,$
ENDSTYLE
END

If you want to renumber on the outer BY field only, use the original LIST:

  
TABLE FILE CAR
LIST MODEL
BY COUNTRY
BY CAR
ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=LIST, SEQUENCE=1,$
ENDSTYLE
END