Solved

number sequence in Crystal Report 8.

Posted on 2004-09-13
4
469 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 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.

Pete
0
 
LVL 1

Author Comment

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

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

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. …
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…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

839 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