Liveware Publishing Support Forum

I created a total field using a count on the Customer_Name, reset on Grand Total, Accumulation on the grouping Customer_Name, and using the Processing as Running. This gave me the result I needed to number the customers when ranked by sales. The RECNO() function was only giving me the actual record ...

How do you number the records found in a list. Starting with the first record found in a sort, then adding 1 to the count for the next record and so on. The end result is a list ranked from 1 to 225 in the left hand margin, example: Top 225 Customers.