Increment records on report

  • Thread starter Thread starter rog
  • Start date Start date
R

rog

I've got a summary report that lists in descending order
the quantity of products sold per period.

I would like to be able to rank these. So "2.5 staples"
were # 99 in period 1,
#56 in period 2,
#83 in period 3.

I can calculate this based on each period, but how do I
number/rank these records?

If it is any help, record one in period one would be
ranked #1 for that period. So all I would need to do is
display the record number.
 
rog said:
I've got a summary report that lists in descending order
the quantity of products sold per period.

I would like to be able to rank these. So "2.5 staples"
were # 99 in period 1,
#56 in period 2,
#83 in period 3.

I can calculate this based on each period, but how do I
number/rank these records?

If it is any help, record one in period one would be
ranked #1 for that period. So all I would need to do is
display the record number.
Click to expand...


If the records are already in the right order, it's easy to
number the. Just use a text box with the expression =1 and
set its RunningSum property to Over Group.
 
Back
Top