• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 479
  • Last Modified:

number sequence in Crystal Report 8.

i'm creating a report that show list of employee. i want to put a numbering sequence in front of each list, like :

1. Mike Lee
2. Steve
3. James

the employee name is from the database. is there any way to create the auto number sequence in Crystal report ?
0
craduza
Asked:
craduza
  • 2
  • 2
1 Solution
 
peter57rCommented:
Hello craduza,

Add the special field 'Record Number' to your report.

Pete
0
 
craduzaAuthor Commented:
Record Number will continuosly displaying the number..but i want the number to be displayed like this :

IT Department
      1. Mike Lee
      2. James

Account Department
      1. Hafida
      2. Gaban Zek
0
 
peter57rCommented:
Right-click on the name field and Insert >RunningTotal
Set the Summary to Count.
Evaluate for each record.
Reset on Change of Group.

Pete
0
 
craduzaAuthor Commented:
TQ Pete...:D
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now