Numbering Rows

[Guest]

My report is as follows:

Position First Name Last Name Points
1 Bob Jones 34
1 Pete Ricks 34
1 Jen Arons 34
4 Andy Russell 38
5 Ben Anders 40
6 Ellen Rush 45
6 Barb Brinkley 45
8 Tim Floyd 46

I would like to display as:


Position First Name Last Name Points
T1 Bob Jones 34
T1 Pete Ricks 34
T1 Jen Arons 34
4 Andy Russell 38
5 Ben Anders 40
T6 Ellen Rush 45
T6 Barb Brinkley 45
8 Tim Floyd 46


The report is sorted (ascending) AND GROUPPED by Points.

I have two non-visible fields in Detail:

RecordCount - not visible, counts all records regardless grouping
GroupCount - not visible, counts record within the group

The RecordCount field's source is =1 and Running sum OVER ALL.
The GroupCount field's source =1, and Running sum OVER GROUP
The Position field's source is:
=IIf([GroupCount]>1,[RecordCount]-([GroupCount]-1),[RecordCount])

Any help would be greatly appreciated.

Phil

 

[Marshall Barton]

My report is as follows:
Position First Name Last Name Points
1 Bob Jones 34
1 Pete Ricks 34
1 Jen Arons 34
4 Andy Russell 38
5 Ben Anders 40
6 Ellen Rush 45
6 Barb Brinkley 45
8 Tim Floyd 46

I would like to display as:
Position First Name Last Name Points
T1 Bob Jones 34
T1 Pete Ricks 34
T1 Jen Arons 34
4 Andy Russell 38
5 Ben Anders 40
T6 Ellen Rush 45
T6 Barb Brinkley 45
8 Tim Floyd 46


The report is sorted (ascending) AND GROUPPED by Points.

I have two non-visible fields in Detail:

RecordCount - not visible, counts all records regardless grouping
GroupCount - not visible, counts record within the group

The RecordCount field's source is =1 and Running sum OVER ALL.
The GroupCount field's source =1, and Running sum OVER GROUP
The Position field's source is:
=IIf([GroupCount]>1,[RecordCount]-([GroupCount]-1),[RecordCount])

Add a text box named GroupTotal to the group header and set
its expression to =Count(*)

Then the Position can use:
=IIf(GroupTotal >1, "T" & (RecordCount - (GroupCount - 1)),
RecordCount)