Objective: I'm trying to generate a report which will automatically generate a sequential 'number' for each record in the found set.

For example: I have a database of students which contains both active and inactive students. Each school quarter, I need to create a list showing just the active students enrolled. The printed list looks like a simple spreadsheet with the fist column (# field) displaying the students number in the list. e.g., the first student record shown would display "1", the second "2", and so on...

=============================

# Student Name

--- ------------

1 Adams, Patick

2 Davis, Myla

3 Jackson, Kendal

4 Smith, Chad

=============================

Question: How do I create these numbers dynamically, so that when I run a report, they are automatically generated for each record? Obviously the number assigned to the record would depend on the sort order. Also, It wouldn't make sense to simply hard code the numeric values, since the values would change based on the total records in the found set.

Any suggestions?

Why not just place the record number itself? You can use Insert > Record Number.

This would change depending upon your sort sequence and always only apply to the found set.

Wonderful! Thanks for the heads up on this feature. I'm still finding my way around FM, and loving it when I learn a new trick or get a good tip.

cheers...

Unfortunately, this didn't work for me. When I generate the report, there are gaps representing records that were deleted. Any ideas?

Thanks!

J