Need line counter to increment every record

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I need a counter to print a incremented number for every
line of report output. In MySQL there is a COUNT()
function that will do what I want but I cannot seem to put
my finger on the solution here. Thanks for your help.

Scott in Charlotte, NC
 
Scott:

There are two ways to do this:

1.) If you need a sequential number starting at one, simply add a field to
the reports underlying query, which has as a value 1 as in:

Counter: 1

Then in the report, for that field, set its running sum to be = true.

2.) You can also do this by adding a sub query to reports underlying query,
to create an autonumber in the query itself. This can be fairly easily
accomplished as outlined on our web site in the Code and Design Tips area,
under Reports, for the tip on creating an auto number for you query.

HTH
 
Back
Top