counting sequence

[eoggb]

CR Version 8.5
Oracle 9

I was looking for a formula that would auto increment a counting sequence for the records printed only (no blank feilds).

1. CCCCCCC
2. fffffffffff
3. dddddddddd

this is a group called accounts and depending on the vendor they may have a number of accounts assigned to them.

it is grouped by client then by the accounts.

 

[lbass]

Why would there be blank groups? You could try just inserting a running total that resets on change of group. If there are in fact groups that are "blank", then add a formula to the evaluation section:

not isnull({table.groupfield}) and
len(trim({table.groupfield})) <> 0

-LB