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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 137
  • Last Modified:

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
0
CraigLazar
Asked:
CraigLazar
  • 2
1 Solution
 
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
 
mlmccCommented:
Use the record number option in the special fields of the field explorer.

good luck
mlmcc
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now