Crystal reports field from db numbering problem

Ok i amk having a simple numbering problem
in my details section of my report, i have a description field from the database, According to my sql
query, there could be one record or 400 according to the criteria in the sql statement

now i need to number them like this

1) Desc 1
2) Desc 1
3) Desc 1
4) Desc 1
..
..
..


5) Desc 1


any help would be great

thanx

Craig
LVL 4
CraigLazarAsked:
Who is Participating?
 
mlmccCommented:
Use the record number option in the special fields of the field explorer.

good luck
mlmcc
0
 
bobbit31Commented:
add a new Running Total Field to your report.
in the wizard set the fields like this:

Field to summarize: primary key of table (or some other field, but i'd suggest pkey)

Type of Summary: count
Evaluate: For each record
Reset: never

Then place this Running total field on your report on your report

0
 
CraigLazarAuthor Commented:
Hi Guys,
thanx for the imput
mimcc - your answer was the quickest
it worked great

thanx
0
 
mlmccCommented:
Glad to help.

Thanks for the help
mlmcc
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.

All Courses

From novice to tech pro — start learning today.