Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

number sequence in Crystal Report 8.

Posted on 2004-09-13
4
Medium Priority
?
476 Views
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 ?
0
Comment
Question by:craduza
  • 2
  • 2
4 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 12042339
Hello craduza,

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

Pete
0
 
LVL 1

Author Comment

by:craduza
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
0
 
LVL 77

Accepted Solution

by:
peter57r earned 200 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.

Pete
0
 
LVL 1

Author Comment

by:craduza
ID: 12042724
TQ Pete...:D
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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 teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Suggested Courses

963 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