Solved

number sequence in Crystal Report 8.

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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 video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

706 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

15 Experts available now in Live!

Get 1:1 Help Now