number sequence in Crystal Report 8.

Posted on 2004-09-13
Last Modified: 2012-08-13
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 ?
Question by:craduza
  • 2
  • 2
LVL 77

Expert Comment

ID: 12042339
Hello craduza,

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


Author Comment

ID: 12042539
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
LVL 77

Accepted Solution

peter57r earned 50 total points
ID: 12042652
Right-click on the name field and Insert >RunningTotal
Set the Summary to Count.
Evaluate for each record.
Reset on Change of Group.


Author Comment

ID: 12042724
TQ Pete...:D

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: (…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now