Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding Row Numbers

Status
Not open for further replies.

Jimdeb03

IS-IT--Management
Dec 10, 2002
89
0
0
US
How do you add Row Numbers to a Group?
I have a list of x number of rows on a report and want to number them 1,2,3...

I don't want to do a Distinct Count Summary of a field which only gives me the total. I need to add a simple counter that increments itself for each record depending on how many are displayed in the report.

version CR 11.0.0.2495

thanks
Jim
 
For row numbers for the entire report, you can go into the field explorer->special fields and select "record number" and add it to the detail section. If you need the number to reset on change of group, then insert a running total that does a count of any recurring (non-null) field, evaluate for each record, reset on change of group.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top